Skip site navigation (1) Skip section navigation (2)

Re: When to vacuum a table?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Craig A(dot) James" <cjames(at)modgraph-usa(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: When to vacuum a table?
Date: 2006-11-26 17:47:38
Message-ID: 4569D33A.9090700@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-performance
> 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
> 


In response to

pgsql-performance by date

Next:From: Jim C. NasbyDate: 2006-11-26 23:25:23
Subject: Re: shared_buffers > 284263 on OS X
Previous:From: Tom LaneDate: 2006-11-26 17:06:06
Subject: Re: When to vacuum a table?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group