Skip site navigation (1) Skip section navigation (2)

Re: caching indexes and pages?

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Thomas Finneid <tfinneid(at)fcon(dot)no>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: caching indexes and pages?
Date: 2009-01-22 15:34:29
Message-ID: 603c8f070901220734k616e9fd2vc42604ebbcbbf449@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
> I tried work_mem and maintenance_work_mem but it does not seem to make much
> difference yet. Admittedly I had set it to 100M and 80M, so after reading a
> little bit more I have found that I could easily set it to several GBs. But
> I am not sure those are the correct config parameters to use for this. I
> havent found any others that are relevant so far.

You probably want to increase shared_buffers by quite a large amount
and maybe make work_mem not quite so big.

If you have 2GB of memory you might set shared_buffers to 1GB,
work_mem 16MB, maintenance_work_mem 64MB?

...Robert

In response to

pgsql-performance by date

Next:From: Bruno BaguetteDate: 2009-01-22 15:36:31
Subject: Slow HashAggregate : How to optimize ?
Previous:From: Thomas FinneidDate: 2009-01-22 12:35:31
Subject: Re: caching written values?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group