Re: [GENERAL] Repeated VACUUM reports same number of deleted rows

2004-10-01 Thread Russell Smith
On Sat, 2 Oct 2004 12:42 am, Tom Lane wrote: > Russell Smith <[EMAIL PROTECTED]> writes: > > Should VACUUM report the rows as deleted or say they could not be deleted? > > Why does it report the same information for three runs in a row? > > I see no pending deletions in that vacuum output: > > >

Re: [GENERAL] Repeated VACUUM reports same number of deleted rows

2004-10-01 Thread Tom Lane
Russell Smith <[EMAIL PROTECTED]> writes: > Should VACUUM report the rows as deleted or say they could not be deleted? > Why does it report the same information for three runs in a row? I see no pending deletions in that vacuum output: > DETAIL: 0 dead row versions cannot be removed yet. so I'm

[GENERAL] Repeated VACUUM reports same number of deleted rows

2004-10-01 Thread Russell Smith
Postgresql 7.4.5 The following VACUUMs were run within a couple of minutes of each other completing. This table concerned is a table that has not been changed in a long time. (a month) There were open transactions at the time the vacuum was run. These were created by having PHP running with post