Skip site navigation (1) Skip section navigation (2)

Re: Looking for tips

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Oliver Crosby <ryusei(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Looking for tips
Date: 2005-07-19 17:50:13
Message-ID: 42DD3D55.9020508@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-performance
Oliver Crosby wrote:
> Hi,
> 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 queries?
What is your structure?
Have you tried explain analyze?
How many rows in the table?
Which OS?
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

Responses

pgsql-performance by date

Next:From: John A MeinelDate: 2005-07-19 17:58:20
Subject: Re: Looking for tips
Previous:From: Oliver CrosbyDate: 2005-07-19 17:42:42
Subject: Looking for tips

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group