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
> insert/update/
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 count
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
sum(pg_stat_get_tuples_inserted(c.oi
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,
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 W
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 o
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.
---(e
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 xact_co