| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Greg Stark <gsstark(at)mit(dot)edu>, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: remove flatfiles.c |
| Date: | 2009-09-02 18:54:40 |
| Message-ID: | 15083.1251917680@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> So I have a script that goes and finds bloated tables and runs VACUUM
> FULL on them in the middle of the night if the bloat passes a certain
> threshold. The tables are small enough and the number of users is low
> enough that this doesn't cause any problems for me. I'm OK if the
> name of the command changes, but I'd like there to be a command that I
> can pass a table name to and get my table debloated without having to
> make any follow-on decisions (such as picking an index to cluster by).
I think we *should* have a command that works like CLUSTER except it just
seqscans the source table without depending on any particular index.
Whether it's called VACUUM FULL or something else is a detail.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2009-09-02 18:56:42 | Re: [COMMITTERS] pgsql: Derived files that are shipped in the distribution used to be |
| Previous Message | Peter Eisentraut | 2009-09-02 18:34:27 | Re: Linux LSB init script |