Re: Need a help - Performance issues

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      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461