the best way to catch table modification - Mailing list pgsql-general

From Marek Lewczuk
Subject the best way to catch table modification
Date
Msg-id 435E6ADB.5000008@lewczuk.com
Whole thread Raw
Responses Re: the best way to catch table modification  (David Gagnon <dgagnon@siunik.com>)
List pgsql-general
Hello,
I'm implementing db-queries caching system - for this I need to know
each table's modification time (or at least modification counter). I
know that I can make a statement-level trigger, which will update a
table with tables modification times - however this is inefficient if
many inserts or updates are made on single table (in single
transaction). The best would be some kind of transaction-level trigger,
but this is not available. Are there any other, better options ?

Thanks in advance.
ML




pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Deleting vs foreign keys
Next
From: Tom Lane
Date:
Subject: Re: STL problem in stored procedures