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

Looking for tips

From: Oliver Crosby <ryusei(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Looking for tips
Date: 2005-07-19 17:42:42
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
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

Next:From: Joshua D. DrakeDate: 2005-07-19 17:50:13
Subject: Re: Looking for tips
Previous:From: Christopher PetrilliDate: 2005-07-19 17:13:05
Subject: Re: Impact of checkpoint_segments under continual load conditions

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