On Friday May 21 2004 1:04, Tom Lane wrote: > "Ed L." <pgsql@bluepolka.net> writes: > > Below are 3 snippets from 3 successive vacuums on a table > > with ~284K rows which receives many many UPDATEs and a few > > INSERTs (there were also a few runs of ANALYZE in between > > these VACUUMs): > > > > INFO: Pages 22652: Changed 4, Empty 0; Tup 284139: Vac 927, Keep 0, > > UnUsed 936. INFO: Pages 22652: Changed 7, Empty 0; Tup 284151: Vac > > 423, Keep 0, UnUsed 1559. INFO: Pages 22652: Changed 4, Empty 0; Tup > > 284155: Vac 221, Keep 0, UnUsed 1823. > > That looks okay to me considering that the physical table size (Pages) > isn't growing. > > > 1) Do the increasing values for "UnUsed" indicate leakage? > > I'm not sure. It seems a bit odd ... could you track this over a longer > interval? An unused tuple slot will only take 4 bytes so it might take > awhile to see any real consequence. Here's a longer interval, or at least a longer sequence: INFO: Pages 22652: Changed 4, Empty 0; Tup 284139: Vac 927, Keep 0, UnUsed 936. INFO: Pages 22652: Changed 7, Empty 0; Tup 284151: Vac 423, Keep 0, UnUsed 1559. INFO: Pages 22652: Changed 4, Empty 0; Tup 284155: Vac 221, Keep 0, UnUsed 1823. INFO: Pages 22652: Changed 2, Empty 0; Tup 284164: Vac 655, Keep 0, UnUsed 1592. INFO: Pages 22652: Changed 1, Empty 0; Tup 284169: Vac 87, Keep 0, UnUsed 2184. INFO: Pages 22652: Changed 1, Empty 0; Tup 284170: Vac 121, Keep 0, UnUsed 2179. INFO: Pages 22652: Changed 0, Empty 0; Tup 284170: Vac 0, Keep 0, UnUsed 2300. INFO: Pages 22652: Changed 0, Empty 0; Tup 284170: Vac 0, Keep 0, UnUsed 2300. INFO: Pages 22652: Changed 1, Empty 0; Tup 284171: Vac 94, Keep 0, UnUsed 2230. INFO: Pages 22652: Changed 0, Empty 0; Tup 284171: Vac 0, Keep 0, UnUsed 2324. INFO: Pages 22652: Changed 0, Empty 0; Tup 284171: Vac 0, Keep 0, UnUsed 2324. INFO: Pages 22652: Changed 1, Empty 0; Tup 284172: Vac 97, Keep 0, UnUsed 2232. INFO: Pages 22652: Changed 1, Empty 0; Tup 284173: Vac 106, Keep 0, UnUsed 2242. INFO: Pages 22652: Changed 0, Empty 0; Tup 284203: Vac 36, Keep 0, UnUsed 2311. I see the UnUsed number stabilizing a bit. (I realize a few of these vacuums were unnecessary). ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
