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

Re: Configuring for maximum memory usage

From: "Scott Carey" <scott(at)richrelevance(dot)com>
To: "Christiaan Willemsen" <cwillemsen(at)technocon(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Configuring for maximum memory usage
Date: 2008-10-30 17:37:23
Message-ID: a1ec7d000810301037iec3e6c5pec2af7a4e3a0c3af@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
>
>  If you do very large aggregates, you may  need  even 1GB on work_mem.
> However, a setting that high would require very careful tuning and reduction
> of space used by shared_buffers and the ZFS ARC.  Its dangerous since each
> connection with a large aggregate or sort may consume a lot of memory.
>
> Well, some taks may need a lot, but I guess most wil do fine with the
> settings we used right now.
>
> So It looks like I can tune the ARC to use more memory, and also increase
> shared_mem to let postgres cache more tables?
>

I would recommend tuning one upwards, and leaving the other smaller.  The
worst case is when they are both similarly sized, it leaves the most
opportunity for duplication of data, and produces the worst feedback on
checkpoint writes.
You may want to compare the performance with:
 larger ARC and smaller shared_buffers
vs
 smaller ARC and larger shared_buffers

The results will be rather dependent on how you use postgres, the types of
queries you do, and for writes, how you tune checkpoints and such.

In response to

pgsql-performance by date

Next:From: Scott CareyDate: 2008-10-30 18:27:09
Subject: Re: Configuring for maximum memory usage
Previous:From: Joshua D. DrakeDate: 2008-10-30 17:26:26
Subject: Re: Configuring for maximum memory usage

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