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

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Csaba NagyDate: 2006-02-27 13:31:33
Subject: neverending vacuum
Previous:From: Javier SomozaDate: 2006-02-27 12:43:36
Subject: Setting the shared buffers

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