There is/was a pg_autotune project, but it was pretty rudamentary and didn't work very well when I tried it circa 2001. Your best bet is probably to either do a lot of research, or hire a consultant.
On Tue, May 09, 2006 at 05:34:26PM +0530, Dhanaraj M wrote: > I am currently looking at some performance issues. Our product uses the > postgres as the backend > and it uses a huge storage space. > > Is there a script available, which does the following: > > > 1. When you point it to a postgres installation, -> 1.the script first > identifies what platform (solaris-sparc/solaris x86/ Niagara) it is > running on, > 2. walks through all known tuning parameters (in /etc/system and > postgresql.conf) on the system > 3. lists out what parameters are optimal/suboptimal for that > platform, and makes recommendations. > 4. identifies when the last vaccumdb /fullvacuum (and other such > database health maintenance commands) were run > 5. comments about the growth of certain tables/databases > > > If any body has the scripts or can give some links which could be useful > for our group. > > > > Thanks > Dhanaraj > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
