Skip site navigation (1) Skip section navigation (2)

Re: to find table stats for last update time.

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Shabala Deshpande <de(dot)shabala(at)gmail(dot)com>
Cc: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: to find table stats for last update time.
Date: 2010-01-05 15:05:19
Message-ID: 407d949e1001050705l255caa9as95e913bd9b3706b6@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Tue, Jan 5, 2010 at 9:37 AM, Shabala Deshpande <de(dot)shabala(at)gmail(dot)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

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2010-01-05 15:12:07
Subject: Re: Help to dump tables in a database and restore in another database
Previous:From: A. KretschmerDate: 2010-01-05 14:53:50
Subject: Re: Using a variable in sql in a function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group