Re: Setting the shared buffers

From: "Claus Guttesen" <kometen(at)gmail(dot)com>
To: "Javier Somoza" <jsomoza(at)pandasoftware(dot)es>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Setting the shared buffers
Date: 2006-02-27 13:17:35
Message-ID: b41c75520602270517u1fd1232ev@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>
> How should i set this configuration? Depending on the memory?
> And then is it necessary to perform a benchmarking test?

I've set it to 'shared_buffers = 12288' with 8 GB RAM on postgresql 7.4.9,
FreeBSD 6.0. There is no exact size, depends on type of workload, server-OS
etc. Adjust it up and down and see if your performance changes.

regards
Claus

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Csaba Nagy 2006-02-27 13:31:33 neverending vacuum
Previous Message Javier Somoza 2006-02-27 12:43:36 Setting the shared buffers