Re: Recording insert, updates, and deletes - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Recording insert, updates, and deletes
Date
Msg-id 20070111105017.GC5836@svana.org
Whole thread Raw
In response to Re: Recording insert, updates, and deletes  ("Andy Dale" <andy.dale@gmail.com>)
List pgsql-general
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/delete and then add this trigger to each table i want to
> record the stats for.  Would this new approach work (i.e. be "lossless") ?

Yes, the stats collector is designed so that if the server is very
busy, it sacrifices accuracy for speed. It's designed to be minimal
impact so that it can be turned on without slowing down your system.

You on the other hand want accuracy over speed, and so the stats
collector is not what you want. Some triggers will do it fine.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: "Andy Dale"
Date:
Subject: Re: Recording insert, updates, and deletes
Next
From: han.holl@informationslogik.nl
Date:
Subject: Optimize expresiions.