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
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
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.
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
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
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
"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)---
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