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: (view raw, whole thread or download thread mbox)
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 -

In response to


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-2017 The PostgreSQL Global Development Group