Hi,
I turned on the stats_row_level in the postgresql.conf file and now the the
calls to the stats functions work. I want to get the inserted, updated, and
deleted numbers on a given database, so i have written a query to do so:
SELECT
sum(pg_stat_get_tuples_inserted(c.oid)) AS inserted,
Andy Dale wrote:
Hi,
I turned on the stats_row_level in the postgresql.conf file and now the the
calls to the stats functions work. I want to get the inserted, updated,
and
deleted numbers on a given database, so i have written a query to do so:
SELECT
Sorry for being stupid, you can select the table info from the pg_class
table, so i can ignore the information schema.
If the stats collector is 'lossy ' i will not be able to use it, can anyone
confirm that it is ? So maybe my best option is to write a simple trigger
that just increments a
On Thu, Jan 11, 2007 at 11:46:17AM +0100, Andy Dale wrote:
If the stats collector is 'lossy ' i will not be able to use it, can anyone
confirm that it is ? So maybe my best option is to write a simple trigger
that just increments a counter (value in a separate table) after an
Hello,
I need to be able to keep track of the number of transactions (the ones that
are committed) that i am interested in, which in my case is all insert,
update, and deletes performed on tables in the public schema. I have
already tried to select xact_commit from pg_stat_database but
On Wed, 2007-01-10 at 16:51 +0100, Andy Dale wrote:
If anyone can help or offer advice on how to achieve my objective it
would be greatly appreciated.
Slony log shipping will do this
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
Hi Brad,
If i have to create a separate slony replication set, then i cannot do it
this way (i cannot and do not want to have a master-slave(s) architecture)
Andy
On 10/01/07, Brad Nicholson [EMAIL PROTECTED] wrote:
On Wed, 2007-01-10 at 16:51 +0100, Andy Dale wrote:
If anyone can help or
On Wed, 2007-01-10 at 12:37, Andy Dale wrote:
Hi Brad,
If i have to create a separate slony replication set, then i cannot do
it this way (i cannot and do not want to have a master-slave(s)
architecture)
Andy
On 10/01/07, Brad Nicholson [EMAIL PROTECTED] wrote:
On Wed,