| From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
|---|---|
| To: | Don Baccus <dhogaza(at)pacifier(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: [HACKERS] Well, then you keep your darn columns |
| Date: | 2000-01-24 20:24:26 |
| Message-ID: | Pine.BSF.4.21.0001241623360.79710-100000@thelab.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, 24 Jan 2000, Don Baccus wrote:
> >you could construe that as a feature --- you don't have to wait around
> >for a DROP COLUMN to finish. Anyone who did want to reclaim space
> >immediately could do
> > UPDATE table SET someothercolumn = someothercolumn;
> >followed by a VACUUM.
>
> Or perhaps vacuum could be made smart enough to remove deleted columns?
> Perhaps optionally?
when bruce and I discussed this, that was one thing we both agreed upon
... Vacuum is too slow as it is, let alone adding in more things for it to
do :(
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ed Loehr | 2000-01-24 20:26:40 | Re: [HACKERS] Well, then you keep your darn columns |
| Previous Message | Don Baccus | 2000-01-24 20:24:11 | Re: [HACKERS] Well, then you keep your darn columns |