Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: When to vacuum a table?
- From: "Joshua D. Drake" <jd(at)commandprompt(dot)com>
- To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Cc: "Craig A. James" <cjames(at)modgraph-usa(dot)com>, pgsql-performance(at)postgresql(dot)org
- Subject: Re: When to vacuum a table?
- Date: Sun, 26 Nov 2006 09:47:38 -0800
If you really want to know, read the mountains of (mostly) junk that have been written about replacing VACUUM in pgsql-hackers. The short answer (with apologies to Winston Churchill) is that VACUUM is the worst solution, except for all the others that have been suggested.
The lesser of 50 evils? ;) Joshua D. Drake
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
- References:
- When to vacuum a table?
- From: Joost Kraaijeveld
- Re: When to vacuum a table?
- From: Marcelo Costa
- Re: When to vacuum a table?
- From: Steinar H. Gunderson
- Re: When to vacuum a table?
- From: Rod Taylor
- Re: When to vacuum a table?
- From: Craig A. James
- Re: When to vacuum a table?
- From: Tom Lane
- When to vacuum a table?
- Prev by Date: Re: When to vacuum a table?
- Next by Date: Re: shared_buffers > 284263 on OS X
- Previous by thread: Re: When to vacuum a table?
- Next by thread: Re: When to vacuum a table?
- Indexes: