Thread: Need a help - Performance issues

Need a help - Performance issues

From
Dhanaraj M
Date:
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/solarisx86/ 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



Re: Need a help - Performance issues

From
"Andrej Ricnik-Bay"
Date:
On 5/10/06, Dhanaraj M <Dhanaraj.M@sun.com> wrote:
> 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.
I thought that's why people still have DBAs ;}


Cheers,
Andrej


--
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm


Re: Need a help - Performance issues

From
"Jim C. Nasby"
Date:
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