| From: | Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Vacuum improvement |
| Date: | 2002-10-16 00:22:06 |
| Message-ID: | Pine.LNX.4.21.0210161010070.930-100000@linuxworld.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi all,
I'm thinking that there is an improvement to vacuum which could be made
for 7.4. VACUUM FULLing large, heavily updated tables is a pain. There's
very little an application can do to minimise dead-tuples, particularly if
the table is randomly updated. Wouldn't it be beneficial if VACUUM could
have a parameter which specified how much of the table is vacuumed. That
is, you could specify:
VACUUM FULL test 20 precent;
Yes, terrible syntax but regardless: this would mean that we could
spread the vacuum out and not, possibly, be backing up queues. ANALYZE
could be modified, if necessary.
Thoughts?
Gavin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-10-16 01:09:05 | Re: COPY syntax |
| Previous Message | Joe Conway | 2002-10-15 23:42:02 | Re: droped out precise time calculations in src/interfaces/libpq/fe-connect.c |