Re: pgsql performance

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: > 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 > > > Jeff MacDonald, ----------------------------------------------------- PostgreSQL Inc | Hub.Org Networking Services jeff@pgsql.com | jeff@hub.org www.pgsql.com | www.hub.org 1-902-542-0713 | 1-902-542-3657 ----------------------------------------------------- Facsimile : 1 902 542 5386 IRC Nick : bignose PGP Public Key : http://bignose.hub.org/public.txt