Re: to find table stats for last update time. - Mailing list pgsql-novice

From Greg Stark
Subject Re: to find table stats for last update time.
Date
Msg-id 407d949e1001050705l255caa9as95e913bd9b3706b6@mail.gmail.com
Whole thread Raw
In response to Re: to find table stats for last update time.  (Shabala Deshpande <de.shabala@gmail.com>)
List pgsql-novice
On Tue, Jan 5, 2010 at 9:37 AM, Shabala Deshpande <de.shabala@gmail.com> wrote:
> I was trying to figure out if i could use any system tables info... but
> seems i have to take the tiggers way out...

Keep in mind that this creates a point of contention and will
serialize all updates against the table. If this is a busy table with
many updates per second it could reduce performance.

--
greg

pgsql-novice by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Using a variable in sql in a function
Next
From: Tom Lane
Date:
Subject: Re: Help to dump tables in a database and restore in another database