Re: [GENERAL] Vacuum analyze vs just Vacuum
"Bryan White" [EMAIL PROTECTED] writes: I would just like to check an assumption. I "vacuum analyze" regularly. I have always assumed that this did a plain vacuum in addition to gathering statistics. Is this true? Yes. There are some poorly-worded places in the docs that make it sound like they might be completely separate operations, but they're not. I would like to split out ANALYZE as a separately-callable command at some point, but we'll no doubt continue to offer the combined "vacuum analyze" command, if only for backward-compatibility reasons... regards, tom lane
Re: [GENERAL] Vacuum analyze vs just Vacuum
I would just like to check an assumption. I "vacuum analyze" regularly. I have always assumed that this did a plain vacuum in addition to gathering statistics. Is this true? The documentation never states explicitly one way or the other but it almost suggests that they are independant operations. Yes, it does a vacuum too. -- Bruce Momjian| http://www.op.net/~candle [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026