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
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
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
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