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
: 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 writes:
> The select query for creating the view is executing fine in 8.4.2. But
>
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, d
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
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 cra