Re: [ADMIN] confused of buffers and memory settings

2008-04-23 Thread Dimitri Fontaine
Le mercredi 23 avril 2008, Gerd König a écrit : > we're quite new to Postgres and we're going to start using Postgres8.3 [...] > What else are "top performance related" options for the usage scenario I > described earlier ? Did you read this document already? http://www.westnet.com/~gsmith/conte

Re: [ADMIN] confused of buffers and memory settings

2008-04-23 Thread Michael Monnerie
On Mittwoch, 23. April 2008 Gerd König wrote: > The db will be accessed heavily (~20 requests/sec.) > with a read/write ration of 50:50, yes, a lot of write activity. Not really heavy, I would say, but maybe your transactions are very big and produce a lot of I/O. > I thought of setting "shared

Re: [ADMIN] confused of buffers and memory settings

2008-04-23 Thread Guillaume Lelarge
Hi, Gerd König a écrit : we're quite new to Postgres and we're going to start using Postgres8.3 on Opensuse10.3 64 bit. We have a dedicated dbserver with 8GB RAM, and now I'm not sure how to deal with the memory/buffer settings. The db will be accessed heavily (~20 requests/sec.) with a read/w

[ADMIN] confused of buffers and memory settings

2008-04-23 Thread Gerd König
Hi, we're quite new to Postgres and we're going to start using Postgres8.3 on Opensuse10.3 64 bit. We have a dedicated dbserver with 8GB RAM, and now I'm not sure how to deal with the memory/buffer settings. The db will be accessed heavily (~20 requests/sec.) with a read/write ration of 50:50