From: John Mendenhall <john@surfutopia.net>
To: Dennis Bjorklund <db@zigo.dhs.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: ported application having performance issues
Date: Fri, 1 Jul 2005 17:52:37 -0700
Message-ID: <20050702005237.GA26087@calvin.surfutopia.net> (raw)
In-Reply-To: <Pine.LNX.4.44.0507011051320.4501-100000@zigo.dhs.org>
References: <20050630235821.GA2163@calvin.surfutopia.net>
<Pine.LNX.4.44.0507011051320.4501-100000@zigo.dhs.org>
Dennis,
On Fri, 01 Jul 2005, Dennis Bjorklund wrote:
> On Thu, 30 Jun 2005, John Mendenhall wrote:
>
> > Our setting for effective_cache_size is 2048.
> >
> > random_page_cost = 4, effective_cache_size = 2048 time approximately 4500ms
> > random_page_cost = 3, effective_cache_size = 2048 time approximately 1050ms
> > random_page_cost = 3, effective_cache_size = 4096 time approximately 1025ms
>
> The effective_cache_size still looks small. As a rule of tumb you might
> want effective_cache_size to be something like 1/2 or 2/3 of your total
> memory. I don't know how much you had, but effective_cache_size = 4096 is
> only 32M.
>
> shared_buffers and effective_cache_size is normally the two most important
> settings in my experience.
I have increased the effective_cache_size to 16384 (128M). I have kept
random_page_cost at 3 for now. This appears to give me the performance
I need at this time.
In the future, we'll look at other methods of increasing the
performance.
Thank you all for all your suggestions.
JohnM
--
John Mendenhall
john@surfutopia.net
surf utopia
internet services
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: john@surfutopia.net, db@zigo.dhs.org
Subject: Re: ported application having performance issues
In-Reply-To: <20050702005237.GA26087@calvin.surfutopia.net>
* 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