Hi Cameron,
One thing you may want to try is the -F tag on startup
this disables disk syncs but is mostly benificial for
writes, versus reads.
Also remember that alot of PgSQL's speed benefits become
aparent with large numbers of concurrent users.
Jeff
On Tue, 6 Feb 2001, Cameron wrote:
> whi
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 kn
Greetings, Cameron!
At 06.02.2001, 14:23, you wrote:
C> whilst i know that mysql is generally faster than pgsql i just tried to
C> convert another of my mysql projects to pgsql, in mysql the list takes
C> about 1 second (SELECT * FROM email LIMIT 0,300 on 18 records), the
C> same query in pg
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 18 records), the
same query in pgsql is taking around 5 seconds, i know i have tweaked
mysql a littl