Re: [GENERAL] Performance Monitoring of PostGRE

2011-07-11 Thread Vincent de Phily
On Wednesday 06 July 2011 14:27:53 BangarRaju Vadapalli wrote: >We want to monitor the performance of PostGRE database. Could anyone > please suggest any tools tried/working successfully... Munin will graph some usefull postgres stats. It's easy enough to graph another datapoint by creating a

Re: [GENERAL] Performance Monitoring of PostGRE

2011-07-06 Thread Tomas Vondra
>> Monitoring PostgreSQL has been a big issue for us since beginning to >> migrate from Oracle, so if anyone else has any experience with this I >> would love to hear other suggestions. > > Most of our monitoring is done through Nagios and Cacti by extracting data > from log files or pg_stat_activ

Re: [GENERAL] Performance Monitoring of PostGRE

2011-07-06 Thread Steve Francis
On Jul 6, 8:44 am, wmo...@potentialtech.com (Bill Moran) wrote: > > > Monitoring PostgreSQL has been a big issue for us since beginning to > > migrate from Oracle, so if anyone else has any experience with this I would > > love to hear other suggestions. > > Most of our monitoring is done throug

Re: [GENERAL] Performance Monitoring of PostGRE

2011-07-06 Thread John R Pierce
On 07/06/11 6:42 AM, Bill Moran wrote: FYI, to follow up on another post. "postgre" is not really an acceptable shortening of PostgreSQL. "postgres" is generally accepted, although there seem to be some people who dislike that as well. "PG" or "PGSQL" also seem to be generally accepted shorten

Re: [GENERAL] Performance Monitoring of PostGRE

2011-07-06 Thread Bill Moran
In response to Bobby Dewitt : > I think by AWR he is referring to Oracle's Automatic Workload Repository. It > automatically gathers information on wait events, object usage, session and > system statistics, etc. It also provides a nice report of what is going on > in your database and can he

Re: [GENERAL] Performance Monitoring of PostGRE

2011-07-06 Thread Bobby Dewitt
I think by AWR he is referring to Oracle's Automatic Workload Repository. It automatically gathers information on wait events, object usage, session and system statistics, etc. It also provides a nice report of what is going on in your database and can help identify bottlenecks that may be cau

Re: [GENERAL] Performance Monitoring of PostGRE

2011-07-06 Thread Michael Nolan
On Wed, Jul 6, 2011 at 3:57 AM, BangarRaju Vadapalli < bangarraju.vadapa...@infor.com> wrote: > Hi Everybody, > > ** ** > >We want to monitor the performance of PostGRE database. Could anyone > please suggest any tools tried/working successfully… > > ** ** > > **1. **We want AWR

Re: [GENERAL] Performance Monitoring of PostGRE

2011-07-06 Thread Bill Moran
In response to BangarRaju Vadapalli : > Hi Everybody, > >We want to monitor the performance of PostGRE database. Could anyone > please suggest any tools tried/working successfully... > > > 1. We want AWR kind of report in Postgres You shouldn't use common acronyms in a question like

Re: [GENERAL] Performance Monitoring of PostGRE

2011-07-06 Thread devrim
This message has been digitally signed by the sender. Re___GENERAL__Performance_Monitoring_of_PostGRE.eml Description: Binary data - Hi-Tech Gears Ltd, Gurgaon, India -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Performance Monitoring of PostGRE

2011-07-06 Thread Devrim GÜNDÜZ
On Wed, 2011-07-06 at 14:27 +0530, BangarRaju Vadapalli wrote: >We want to monitor the performance of PostGRE database I am not aware of a database called PostGRE. -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat

[GENERAL] Performance Monitoring of PostGRE

2011-07-06 Thread BangarRaju Vadapalli
Hi Everybody, We want to monitor the performance of PostGRE database. Could anyone please suggest any tools tried/working successfully... 1. We want AWR kind of report in Postgres 2. We would like to do CPU Utilization monitoring based on the postgres processes Thanks in Advan