pgsql performance
| From: | Cameron | Date: | Tue, 06 Feb 2001 05:45:37 +0000 |
| Subject: | pgsql performance | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-6413@lists.php.net to get a copy of this message | ||
whilst i know that mysql is generally faster than pgsql i just tried to
convert another of my mysql projects to pgsql, in mysql the list takes
about 1 second (SELECT * FROM email LIMIT 0,300 on 180000 records), the
same query in pgsql is taking around 5 seconds, i know i have tweaked
mysql a little and played with things to make it faster, i was wondering
if there are any tips to pgsql? i didnt think pgsql was that slow :(
Cameron