Re: (one more time) Patches with vacuum fixes available .

* Andrew Snow <als@fl.net.au> [001211 20:21] wrote:
> 
> On Mon, 11 Dec 2000, Tom Lane wrote:
> 
> > "Mikheev, Vadim" <vmikheev@SECTORBASE.COM> writes:
> > > If there are no objections then I'm ready to add changes to 7.1.
> > > Else, I'll produce patches for 7.1 just after release and incorporate
> > > changes into 7.2.
> > 
> > I'd vote for the second choice.  I do not think we should be adding new
> > features now.  Also, I don't know about you, but I have enough bug fix,
> > testing, and documentation work to keep me busy till January even
> > without any new features...
> 
> It'd be really naughty to add it to the beta at this stage.  Would it be
> possible to add it to the 7.1 package with some kind of compile-time option?
> So that those of us who do want to use it, can.

One is a compile time option (CFLAGS+=-DMMNB), the other doesn't
happen unless you ask for it:

vacuum lazy <table>;

I don't understand what the deal here is, as I said, it's optional
code that you won't see unless you ask for it.
           [children: 0 12/11/2000 21:57:20 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx]
Vacuuming link.           [children: 0 12/11/2000 21:57:54 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx]

-rw-------  1 pgsql  pgsql  134627328 Dec 11 21:57 link
-rw-------  1 pgsql  pgsql  261201920 Dec 11 21:57 link_triple_idx

Yup, 30 seconds, the table is 134 megabytes and the index is 261 megs.

I think normally this takes about 10 or so _minutes_.

On our faster server:
           [children: 0 12/11/2000 22:17:50 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx]
Vacuuming referer_link.           [children: 0 12/11/2000 22:18:09 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx]

-rw-------  1 pgsql  wheel  273670144 Dec 11 22:15 link
-rw-------  1 pgsql  wheel  641048576 Dec 11 22:15 link_triple_idx

time is ~19seconds, table is 273 megs, and index 641 megs.

dual 800mhz, raid 5 disks.

I think the users deserve this patch. :)

-- 
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."