Re: Tuning configuration

On Dec 4, 2007, at 11:17 AM, Konrad Neuwirth wrote:

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

What version of postgres are you using? 8.3 (currently in beta) has
facilities for tracking temp file creation.

Erik Jones

Software Developer | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com