Postgres Pro
Downloads
Home   >   mailing lists

Looking for tips - Mailing list pgsql-performance

From Oliver Crosby
Subject Looking for tips
Date
Msg-id 1efd553a05071910427b290203@mail.gmail.com
Whole thread Raw
Responses Re: Looking for tips  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Looking for tips  (John A Meinel <john@arbash-meinel.com>)
Re: Looking for tips  (Richard Huxton <dev@archonet.com>)
List pgsql-performance
Tree view
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%.
I upped the sort_mem to 8192 (kB), and shared_buffers and effective_cache_size to 65536 (512MB), but neither the timing nor the server load have changed at all. FYI, I'm going to be working on data sets in the order of GB.
 
I think I've gone about as far as I can with google.. can anybody give me some advice on how to improve the raw performance before I start looking at code changes?
 
Thanks in advance.

pgsql-performance by date:

Previous
From: Christopher Petrilli
Date:
Subject: Re: Impact of checkpoint_segments under continual load conditions
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Looking for tips