Re: sequence indexes

On Fri, 25 Jan 2002, Tom Lane wrote:

> Vince Vielhaber <vev@michvhf.com> writes:
> > A bit much diskspace for that, isn't it?   The data turns over alot.
>
> Yeah, this is one of the scenarios where we desperately need index
> compaction.  The index pages holding the lower serial numbers are
> no doubt empty or nearly so, but there's no mechanism for reclaiming
> that space short of rebuilding the index.  (BTW you might consider
> REINDEX instead of a manual drop/recreate.)

I'm guessing reindex wasn't in 6.5.3. :(


Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net        56K Nationwide Dialup from $16.00/mo
atPop4 Networking       Online Campground Directory    http://www.camping-usa.com      Online Giftshop Superstore
http://www.cloudninegifts.com
==========================================================================