On Thu, Dec 10, 2009 at 11:45 AM, Greg Smith wrote:
> So your shared buffers setting is 8192 * 8K = 64MB
> effective_cache_size is 8MB
> work_mem is 4MB.
>
> The first and last of those are reasonable but on the small side, the last
> is...not.
I believe that the second instance of the word "last
Mark Stosberg wrote:
I find the file a bit hard to read because of the lack of units in
the examples, but perhaps that's already been addressed in future
versions.
max_connections= 400 # Seems to be enough us
shared_buffers = 8192
effective_cache_size = 1000
work_mem
On Thu, 10 Dec 2009, Mark Stosberg wrote:
What I'm noticing is that the while the FreeBSD server has 4 Gigs of
memory, there are rarely every more than 2 in use-- the memory use
graphs as being rather constant. My goal is to make good use of those 2
Gigs of memory to improve performance and reduc
Hello,
PostgreSQL has served us very well powering a busy national pet
adoption website. Now I'd like to tune our setup further get more out
of hardware.
What I'm noticing is that the while the FreeBSD server has 4 Gigs of
memory, there are rarely every more than 2 in use-- the memory use
grap