Postgres Pro
Downloads
Home   >   mailing lists

Re: Inconsistent performance - Mailing list pgsql-performance

From Matt Clark
Subject Re: Inconsistent performance
Date
Msg-id LFEIJBEOKGPDHCEMDGNFMEHGCCAA.matt@ymogen.net
Whole thread Raw
In response to Re: Inconsistent performance  (Joseph Bove <jbove@vetstar.com>)
List pgsql-performance
Tree view 
...
> #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

pgsql-performance by date:

Previous
From: Paul Thomas
Date:
Subject: Re: Attempt at work around of int4 query won't touch int8 index ...
Next
From: Vivek Khera
Date:
Subject: Re: restore time: sort_mem vs. checkpoing_segments