I have no personal experience with pgsql... but I've heard from friends
and in a number of articles strong suggestions to upgrade to pgsql
7.0. It is noticably faster. Also I believe the Postgres docs have a
section on performance tuning.
Mark
On Tue, 6 Feb 2001, Cameron wrote:
> 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
>
>
>
--
"The greatest dangers to liberty lurk in insidious enroachment by mean of
zeal, well-meaning but without understanding."
-- Justice Louis O. Brandeis, Olmstead vs. United States
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]