From: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
---|---|
To: | "Erik Jones" <erik(at)myemma(dot)com>, "Konrad Neuwirth" <k(dot)neuwirth(at)gmail(dot)com> |
Cc: | "Postgresql" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Tuning configuration |
Date: | 2007-12-04 19:21:43 |
Message-ID: | D7FF158337303A419CF4A183F48302D6036CB1FF@hdsmsx411.amr.corp.intel.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Is there something like a freeware windows client app that does DBA
stuff for a remote server? Sort of like TOAD for Oracle?
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Erik Jones
Sent: Tuesday, December 04, 2007 1:34 PM
To: Konrad Neuwirth
Cc: Postgresql
Subject: Re: [GENERAL] 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(r)
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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
From | Date | Subject | |
---|---|---|---|
Next Message | John Wells | 2007-12-04 19:26:21 | Re: Recovering data via raw table and field separators |
Previous Message | Daniel Schuchardt | 2007-12-04 19:15:30 | Re: bug with >to_char('2007-12-31'::DATE, 'YYYYIW')< |