| From: | Dhanaraj M <Dhanaraj(dot)M(at)Sun(dot)COM> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Need a help - Performance issues |
| Date: | 2006-05-09 12:04:26 |
| Message-ID: | 4460854A.5000604@sun.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-05-09 13:31:56 | Re: Big IN() clauses etc : feature proposal |
| Previous Message | PFC | 2006-05-09 11:29:56 | Re: [HACKERS] Big IN() clauses etc : feature proposal |