Postgres Pro
Downloads
Home   >   mailing lists

Re: Setting the shared buffers - Mailing list pgsql-performance

From Claus Guttesen
Subject Re: Setting the shared buffers
Date
Msg-id b41c75520602270517u1fd1232ev@mail.gmail.com
Whole thread Raw
In response to Setting the shared buffers  (Javier Somoza <jsomoza@pandasoftware.es>)
List pgsql-performance
Tree view
            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

pgsql-performance by date:

Previous
From: Javier Somoza
Date:
Subject: Setting the shared buffers
Next
From: Csaba Nagy
Date:
Subject: neverending vacuum