Oliver Crosby wrote:
> I'm running Postgres 7.4.6 on a dedicated server with about 1.5gigs of ram.
> Running scripts locally, it takes about 1.5x longer than mysql, and the
> load on the server is only about 21%.
What is your structure?
Have you tried explain analyze?
How many rows in the table?
How are you testing the speed?
What type of RAID?
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
In response to
pgsql-performance by date
|Next:||From: John A Meinel||Date: 2005-07-19 17:58:20|
|Subject: Re: Looking for tips|
|Previous:||From: Oliver Crosby||Date: 2005-07-19 17:42:42|
|Subject: Looking for tips|