| From: | Decibel! <decibel(at)decibel(dot)org> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | Tatsuo Ishii <ishii(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development list <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Re: [COMMITTERS] pgsql: Fix free space map to correctly track the total amount of FSM |
| Date: | 2007-10-04 05:02:55 |
| Message-ID: | 20071004050254.GL65515@decibel.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-hackers |
On Tue, Oct 02, 2007 at 09:07:54PM -0400, Alvaro Herrera wrote:
> Decibel! wrote:
>
> > Hrm... what about adding output to vacuum verbose that indicates how many
> > pages in a relation have free space? That would allow something like
> > pgfouine to see how many FSM pages were needed. It would also make it
> > easier to identify relations that could stand a vacuum full/reindex/cluster
> > (though you'd also want to know something like average free space per
> > page).
>
> Rather than wasting time fixing minor FSM issues, I would favor
> rewriting the stuff so that the FSM is disk-spillable.
Sure, but this would also likely be a 20 line change to vacuum...
--
Decibel!, aka Jim C. Nasby, Database Architect decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2007-10-04 06:23:49 | Re: Re: [COMMITTERS] pgsql: Fix free space map to correctly track the total amount of FSM |
| Previous Message | Neil Conway | 2007-10-04 03:57:00 | Re: pgsql: Second pass at 8.3 release notes: put items in a bit more logical |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2007-10-04 06:23:49 | Re: Re: [COMMITTERS] pgsql: Fix free space map to correctly track the total amount of FSM |
| Previous Message | Tom Lane | 2007-10-04 04:47:13 | Not *quite* there on ecpg fixes |