Re: [HACKERS] Vacuum summary?

2005-07-29 Thread Bruce Momjian
Added to TODO: * Add system view to show free space map contents --- Simon Riggs wrote: > On Tue, 2005-07-12 at 14:56 -0700, Joshua D. Drake wrote: > > > It'd be relatively easy I think to extract the current FSM s

Re: [HACKERS] Vacuum summary?

2005-07-13 Thread Simon Riggs
On Tue, 2005-07-12 at 14:56 -0700, Joshua D. Drake wrote: > > It'd be relatively easy I think to extract the current FSM statistics > > in a function that could be invoked separately from VACUUM. Not sure > > how we ought to return 'em though --- the VACUUM way of a bunch of INFO > > messages is a

Re: [HACKERS] Vacuum summary?

2005-07-12 Thread Joshua D. Drake
It'd be relatively easy I think to extract the current FSM statistics in a function that could be invoked separately from VACUUM. Not sure how we ought to return 'em though --- the VACUUM way of a bunch of INFO messages is a bit old-fashioned. Maybe a statistics view? That would work for me.

Re: [HACKERS] Vacuum summary?

2005-07-12 Thread Tom Lane
Simon Riggs <[EMAIL PROTECTED]> writes: > On Mon, 2005-07-11 at 12:38 -0700, Joshua D. Drake wrote: >>> What do you guys think of having a vacuum summary command? E.g.; > How about putting this in the logfile, without any command changes? Actually, tying it to VACUUM might not have been such a gr

Re: [HACKERS] Vacuum summary?

2005-07-12 Thread Simon Riggs
On Mon, 2005-07-11 at 12:38 -0700, Joshua D. Drake wrote: > Tom Lane wrote: > > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > > > >>What do you guys think of having a vacuum summary command? E.g.; > > > > > >>VACUUM [FULL] [ANALYZE] SUMMARY > > > > > > ... that will turn SUMMARY into a fully

Re: [HACKERS] Vacuum summary?

2005-07-11 Thread Joshua D. Drake
Tom Lane wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: What do you guys think of having a vacuum summary command? E.g.; VACUUM [FULL] [ANALYZE] SUMMARY ... that will turn SUMMARY into a fully reserved word ... Hmmm... good point. Other options would be: brief short terse? nutsh

Re: [HACKERS] Vacuum summary?

2005-07-11 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > What do you guys think of having a vacuum summary command? E.g.; > VACUUM [FULL] [ANALYZE] SUMMARY ... that will turn SUMMARY into a fully reserved word ... regards, tom lane ---(end of broadcast)---

[HACKERS] Vacuum summary?

2005-07-11 Thread Joshua D. Drake
Hello, What do you guys think of having a vacuum summary command? E.g.; VACUUM [FULL] [ANALYZE] SUMMARY where summary would only print the last lines of a vacuum verbose? foo=> VACUUM SUMMARY; INFO: free space map contains 17 pages in 12 relations DETAIL: A total of 192 page slots are in use