| From: | Vince Vielhaber <vev(at)michvhf(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: sequence indexes |
| Date: | 2002-01-25 21:00:03 |
| Message-ID: | Pine.BSF.4.40.0201251559100.47994-100000@paprika.michvhf.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, 25 Jan 2002, Tom Lane wrote:
> Vince Vielhaber <vev(at)michvhf(dot)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(at)michvhf(dot)com http://www.pop4.net
56K Nationwide Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-01-25 21:01:11 | Re: sequence indexes |
| Previous Message | Tom Lane | 2002-01-25 20:56:05 | Re: sequence indexes |