Re: [PERFORM] Vacuum not identifying rows for removal..

2006-08-22 Thread Eamonn Kent
> > > Thanks > > Ike > > > > > -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: Monday, August 21, 2006 2:06 PM > To: Eamonn Kent > Cc: pgsql-performance@postgresql.org > Subject: Re: [PERFORM] Vacuum not identifyi

Re: [PERFORM] Vacuum not identifying rows for removal..

2006-08-21 Thread Eamonn Kent
: Monday, August 21, 2006 2:06 PM To: Eamonn Kent Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Vacuum not identifying rows for removal.. "Eamonn Kent" <[EMAIL PROTECTED]> writes: > I am using PostgreSQL 8.1.4 for an embedded application. For some > reason, vacuum i

[PERFORM] Vacuum not identifying rows for removal..

2006-08-21 Thread Eamonn Kent
Hi,   I am using PostgreSQL 8.1.4 for an embedded application.  For some reason, vacuum is not able to identify rows that are candidates for removal (i.e., mark space as available).   Background Info:   I observed some performance problems – our database seemed to be using an unusuall