[GENERAL] Performance Monitoring of PostGRE

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

Re: [GENERAL] Forward referencing of table aliases in subqueries does not work in 9.1 beta2 ( works in 9.0 and 8.4.2 )

To: BangarRaju Vadapalli Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Forward referencing of table aliases in subqueries does not work in 9.1 beta2 ( works in 9.0 and 8.4.2 ) BangarRaju Vadapalli bangarraju.vadapa...@infor.com writes: The select query for creating the view is executing

Re: [GENERAL] random backend crashes - how to debug ( Is crash dump handler released ? )

Answers Below -Original Message- From: Craig Ringer [mailto:cr...@postnewspapers.com.au] Sent: Sunday, June 19, 2011 3:03 PM To: BangarRaju Vadapalli Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] random backend crashes - how to debug ( Is crash dump handler released

[GENERAL] Forward referencing of table aliases in subqueries does not work in 9.1 beta2 ( works in 9.0 and 8.4.2 )

Hi Everybody, We have a view defined like below. CREATE OR REPLACE VIEW dim_agg_instr_actuals_view AS SELECT dbai.dim_base_agg_instr_key AS instr_key, dba.dim_base_key AS basekey, dl.datamart_letter, dba.agg_number AS aggnum, dl.enabled, dba.dim_base_agg_key, dbai.dim_base_name,

[GENERAL] random backend crashes - how to debug ( Is crash dump handler released ? )

Hi Everybody, We are using PostGRE 8.4 version and experiencing random backend crashes. We have enabled logging and are able to see some logging happening in pg_log directory but not of much use. Here are the logs. 2011-06-14 18:06:04 IST WARNING: terminating connection because of