I need to provide recommendations for optimal value for the
shared_buffers. This has to do with some optional feature
we have in our application. If turned on - a number of extra
tables involved in the operations.
I don't have an experience with PG perf. testing and I guess that 
I may need to account for the size of the tables, perhaps the size
of index tables as well..?

Any hints, or pointers to related reading would be very appreciated.
Mike.


Thu, 15 Jan 2004 16:48:55 -0500
Michael Brusser <michael@synchronicity.com>
Postgres v.7.3.4 - Performance tuning
On Thursday 15 January 2004 21:48, Michael Brusser wrote:
> I need to provide recommendations for optimal value for the
> shared_buffers. 

> Any hints, or pointers to related reading would be very appreciated.
> Mike.

First, read the annotated config file and performance guide here:
http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php

If you think there's more to be done, subscribe to the performance list
http://www.postgresql.org/lists.html

-- 
  Richard Huxton
  Archonet Ltd

Fri, 16 Jan 2004 09:15:24 +0000
Richard Huxton <dev@archonet.com>
Re: Postgres v.7.3.4 - Performance tuning