| From: | "Mark Cave-Ayland" <m(dot)cave-ayland(at)webbased(dot)co(dot)uk> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "PostgreSQL General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: 7.3.1 takes long time to vacuum table? |
| Date: | 2003-02-20 17:25:57 |
| Message-ID: | C1379626F9C09A4C821D6977AA6A54570634E9@webbased8.wb8.webbased.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi Tom,
> I suspect that what we really want here is a completely different
> algorithm (viz copy into a new file, like CLUSTER) when the initial
scan
> reveals that there's more than X percent of free space in the file.
Yes! Sorry Tom, I missed the detail of this the first time around.
However from the figures here it would need to be a very small
percentage of free space, perhaps only upto 10-15% where the existing
vacuum would be a better method. Hope they were useful to you.
Cheers,
Mark.
---
Mark Cave-Ayland
Webbased Ltd.
Tamar Science Park
Derriford
Plymouth
PL6 8BX
England
Tel: +44 (0)1752 764445
Fax: +44 (0)1752 764446
This email and any attachments are confidential to the intended
recipient and may also be privileged. If you are not the intended
recipient please delete it from your system and notify the sender. You
should not copy it or use it for any purpose nor disclose or distribute
its contents to any other person.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Beutin | 2003-02-20 17:31:07 | Re: max connections |
| Previous Message | Mark Cave-Ayland | 2003-02-20 17:22:32 | Re: 7.3.1 takes long time to vacuum table? |