Tuning configuration

From: "Konrad Neuwirth" <k(dot)neuwirth(at)gmail(dot)com>
To: Postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Tuning configuration
Date: 2007-12-04 17:17:22
Message-ID: 788d884a0712040917j2a8cbdb1o412537a57ed4442@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have a hopefully simple question. I've found documentation about
the meanings of the various variables in postgres.conf -- if it comes
to memory consumption and buffer size. I've also found hints as to
making them too large decreases performance. But -- how can I measure
how well the current settings fit? Are there tables to watch on how
quickly things like temp tables get written out to disk vs. being held
in memory? We'd like to find an appropriate size for our database,
but can't even yet say if we're in the right ballpark on a machine
that has RAM to spare still.

What can I look into?

Thank you,
Konrad Neuwirth

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Wells 2007-12-04 17:34:51 Recovering data via raw table and field separators
Previous Message Richard Huxton 2007-12-04 17:10:51 Re: WAL shipping question