Re: [HACKERS] Postgres v.7.3.4 - Performance tuning

2004-01-16 Thread Richard Huxton
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.va

[HACKERS] Postgres v.7.3.4 - Performance tuning

2004-01-15 Thread Michael Brusser
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 acco