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
==========================================================================