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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Erik Jones Sent: Tuesday, December 04, 2007 1:34 PM To: Konrad Neuwirth Cc: Postgresql Subject: 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(r) erik@xxxxxxxxxx 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
