Re: [PATCHES] VACUUM VERBOSE FSM info

2005-04-23 Thread Bruce Momjian
OK, new text is: INFO: free space map contains 36 pages in 51 relations DETAIL: A total of 816 page slots are in use (including overhead). 816 page slots are required to track all free space. Current limits are: 18000 page slots, 1000 relations, using 17

Re: [PATCHES] VACUUM VERBOSE FSM info

2005-04-23 Thread Tom Lane
Bruce Momjian writes: > Should the "memory used" line be a hint? Well, the main message should fit on one line, and the rest is either hint or detail. In this case detail since it's all facts, not advice. Could look like this: INFO: free space map contains N1 pages in N2 relations DETAIL: A tot

Re: [PATCHES] VACUUM VERBOSE FSM info

2005-04-23 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > What goes in the remaining 5276 (19300-14024) page entries anyway? That's overhead forced by the quantized allocation of FSM slots. regards, tom lane ---(end of broadcast)--- TIP

Re: [PATCHES] VACUUM VERBOSE FSM info

2005-04-23 Thread Alvaro Herrera
On Sat, Apr 23, 2005 at 05:16:09PM -0400, Bruce Momjian wrote: > Well, the number you highlighted might not equal the number on the next > line if you don't have enough entries to store all the free space, e.g.: > > INFO: free space map contains information about: > 49 relations, lim

Re: [PATCHES] VACUUM VERBOSE FSM info

2005-04-23 Thread Bruce Momjian
Alvaro Herrera wrote: > On Sat, Apr 23, 2005 at 04:55:37PM -0400, Bruce Momjian wrote: > > One question, > > > INFO: free space map contains information about: > > 49 relations, limit 1000 relations > > 35 pages with free space, 784 pages (with overhead) >

Re: [PATCHES] VACUUM VERBOSE FSM info

2005-04-23 Thread Alvaro Herrera
On Sat, Apr 23, 2005 at 04:55:37PM -0400, Bruce Momjian wrote: One question, > INFO: free space map contains information about: > 49 relations, limit 1000 relations > 35 pages with free space, 784 pages (with overhead) ^ > 784 pag