to delete duplicate rows
Have fun
From: Jason Long
To: Guillaume Lelarge
Cc: Craig Ringer ; pgsql-general@postgresql.org
Sent: Friday, September 30, 2011 12:12 AM
Subject: Re: [GENERAL] Identifying old/unused views and table
On Wed, 2011-09-28 at 08:52 +020
On Wed, 2011-09-28 at 08:52 +0200, Guillaume Lelarge wrote:
> On Wed, 2011-09-28 at 09:04 +0800, Craig Ringer wrote:
> > On 09/28/2011 04:51 AM, Jason Long wrote:
> > > I have an application with a couple hundred views and a couple hundred
> > > tables.
> > >
> > > Is there some way I can find out
On Wed, 2011-09-28 at 09:04 +0800, Craig Ringer wrote:
> On 09/28/2011 04:51 AM, Jason Long wrote:
> > I have an application with a couple hundred views and a couple hundred
> > tables.
> >
> > Is there some way I can find out which views have been accessed in the
> > last 6 months or so? Or some
On 09/28/2011 04:51 AM, Jason Long wrote:
I have an application with a couple hundred views and a couple hundred
tables.
Is there some way I can find out which views have been accessed in the
last 6 months or so? Or some way to log this?
I know there are views and tables that are no longer in
I have an application with a couple hundred views and a couple hundred
tables.
Is there some way I can find out which views have been accessed in the
last 6 months or so? Or some way to log this?
I know there are views and tables that are no longer in used by my
application and I am looking for
