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
Thanks in advance.
pgsql-performance by date
|Next:||From: Joshua D. Drake||Date: 2005-07-19 17:50:13|
|Subject: Re: Looking for tips|
|Previous:||From: Christopher Petrilli||Date: 2005-07-19 17:13:05|
|Subject: Re: Impact of checkpoint_segments under continual load conditions|