Re: Inconsistent performance

From: "Matt Clark" <matt(at)ymogen(dot)net>
To: "Joseph Bove" <jbove(at)vetstar(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Inconsistent performance
Date: 2003-09-16 08:31:01
Message-ID: LFEIJBEOKGPDHCEMDGNFMEHGCCAA.matt@ymogen.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

...
> #effective_cache_size = 1000 # typically 8KB each

That's horribly wrong. It's telling PG that your OS is only likely to cache
8MB of the DB in RAM. If you've got 1GB of memory it should be between
64000 and 96000

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Vivek Khera 2003-09-16 13:59:14 Re: restore time: sort_mem vs. checkpoing_segments
Previous Message Paul Thomas 2003-09-16 07:44:48 Re: Attempt at work around of int4 query won't touch int8 index ...