Re: [HACKERS] VACUUM VERBOSE 8.1dev

2005-09-14 Thread Dave Cramer
I'm not even sure that the new output does tell me the same thing. I certainly prefer the previous output. I think this will be very confusing to users who aren't familiar with the internals of postgres. Dave On 13-Sep-05, at 11:44 PM, Joshua D. Drake wrote: Hello, It seems the new VACUUM

Re: [HACKERS] VACUUM VERBOSE 8.1dev

2005-09-13 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > It seems the new VACUUM VERBOSE output is not quite as helpful as 8.0. > In 8.0 I get a nice output at the end like this: > INFO: free space map: 1377 relations, 22478 pages stored; 44112 total > pages needed > DETAIL: Allocated FSM size: 10 r

Re: [HACKERS] VACUUM VERBOSE 8.1dev

2005-09-13 Thread Joshua D. Drake
INFO: free space map: 1377 relations, 22478 pages stored; 44112 total pages needed DETAIL: Allocated FSM size: 10 relations + 200 pages = 17702 kB shared memory. AFAIR, in both 8.0 and 8.1 that info appears only at the end of a database-wide vacuum. Your example is a single-ta

[HACKERS] VACUUM VERBOSE 8.1dev

2005-09-13 Thread Joshua D. Drake
Hello, It seems the new VACUUM VERBOSE output is not quite as helpful as 8.0. In 8.0 I get a nice output at the end like this: INFO: free space map: 1377 relations, 22478 pages stored; 44112 total pages needed DETAIL: Allocated FSM size: 10 relations + 200 pages = 17702 kB shared mem