Search Postgresql Archives

Re: Way to quickly detect if database tables/columns/etc. were modified?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Not sure if it would work for your use-case but what about just monitoring the PostgreSQL log for DDL statements? You may have to filter out temp tables (as you might in the system catalogs as well) but you could probably also watch for specific tablename patterns in case you only need to invalidate cache under specific circumstances.

Cheers,
Steve


On Mon, Oct 31, 2016 at 7:17 AM, Melvin Davidson <melvin6925@xxxxxxxxx> wrote:


On Mon, Oct 31, 2016 at 9:48 AM, Karsten Hilbert <Karsten.Hilbert@xxxxxxx> wrote:
On Mon, Oct 31, 2016 at 09:14:07AM -0400, Melvin Davidson wrote:

>> Maybe create an event trigger that updates a simple table with the last
>> modification time or sends a notification?
...
> That would certainly work, but
> the problem is, that trigger would have to be created for every table in
> the database. When you have more than a couple dozen tables, as in
> hundreds, it becsmes a huge undertaking.*--

Well, it could be generated.

Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

>Well, it could be generated.
True, but it still is more code to maintain, whereas I maintain the addition addition of one column in pg_class and pg_attribute with a default of now()
would make more sense. That being said, there were so many naysayers grasping at corner cases the last time I brought this up I have given up
pursuing it.

--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux