From: Sean Chittenden <sean@chittenden.org>
To: peter <pmcgregor@advso.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance issue
Date: Wed, 24 Sep 2003 10:47:21 -0700
Message-ID: <20030924174721.GA11474@perrin.nxad.com> (raw)
In-Reply-To: <B10D0E1A-EE52-11D7-BD6E-003065E5EDC4@advso.com>
References: <B10D0E1A-EE52-11D7-BD6E-003065E5EDC4@advso.com>
> My statistics(Athlon 1.8Ghz)
> ----------------
> 20,000 items Takes on average 0.078seconds/room
> 385,000 items Takes on average .11seconds/room
> 690,000 items takes on average .270seconds/room
> 1,028,000 items Takes on average .475seconds/room
[snip]
> I am running Red hat 8. Some of my conf entries that I have changed
> follow
> shared_buffers = 3700
> effective_cache_size = 4000
> sort_mem = 32168
Have you twiddled with your wal_buffers or checkpoint_segments? Might
be something to look at.
-sc
--
Sean Chittenden
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sean@chittenden.org, pmcgregor@advso.com
Subject: Re: Performance issue
In-Reply-To: <20030924174721.GA11474@perrin.nxad.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox