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
[EMAIL PROTECTED] | [EMAIL PROTECTED]
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
--
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]
