| From: | Dustin Sallings <dustin(at)spy(dot)net> |
|---|---|
| To: | Forest Wilkinson <fspam(at)home(dot)com> |
| Cc: | pgsql-general(at)hub(dot)org |
| Subject: | Re: Is VACUUM ANALYZE a superset of VACUUM? |
| Date: | 2000-10-13 23:15:15 |
| Message-ID: | Pine.SGI.3.95.1001013161404.21383C-100000@bleu.west.spy.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 13 Oct 2000, Forest Wilkinson wrote:
# Does running "VACUUM ANALYZE" incorporate the effects of a plain old
# "VACUUM"? Or, must I run both "VACUUM" and "VACUUM ANALYZE" to have old
# rows removed *and* statistics gathered? The docs aren't clear about
# this.
I'm quite sure ``vacuum analyze'' does both. Is there a reason
there's no ``analyze?'' I guess it doesn't make too much of a difference
without time travel.
--
SA, beyond.com My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin(at)spy(dot)net>
| Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-10-14 00:42:06 | Re: How does TOAST compare to other databases' mechanisms? |
| Previous Message | Forest Wilkinson | 2000-10-13 23:11:42 | Is VACUUM ANALYZE a superset of VACUUM? |