| Lists: | pgsql-docs |
|---|
| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org> |
| Subject: | vacuumdb clarification |
| Date: | 2009-11-13 19:49:20 |
| Message-ID: | 200911131949.nADJnKQ02721@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-docs |
Here is a documentation patch I have applied to clarify that --analyze
does analyze during vacuum, not instead of vacuum.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| Attachment | Content-Type | Size |
|---|---|---|
| /rtmp/diff | text/x-diff | 814 bytes |
| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org> |
| Subject: | Re: vacuumdb clarification |
| Date: | 2009-11-20 13:58:09 |
| Message-ID: | 1258725489.28720.12.camel@fsopti579.F-Secure.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-docs |
On fre, 2009-11-13 at 14:49 -0500, Bruce Momjian wrote:
> Here is a documentation patch I have applied to clarify that --analyze
> does analyze during vacuum, not instead of vacuum.
I don't see this committed, but I would vote against it, because the
wording makes it sound like the statistics are for use by the optimizer
during vacuum.
diff -c -c -r1.44 vacuumdb.sgml
*** doc/src/sgml/ref/vacuumdb.sgml 26 Feb 2009 16:02:37 -0000
1.44
--- doc/src/sgml/ref/vacuumdb.sgml 13 Nov 2009 19:46:37 -0000
***************
*** 159,165 ****
<term><option>--analyze</option></term>
<listitem>
<para>
! Calculate statistics for use by the optimizer.
</para>
</listitem>
</varlistentry>
--- 159,165 ----
<term><option>--analyze</option></term>
<listitem>
<para>
! Calculate statistics for use by the optimizer during vacuum.
</para>
</listitem>
</varlistentry>
| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org> |
| Subject: | Re: vacuumdb clarification |
| Date: | 2009-11-27 17:41:37 |
| Message-ID: | 200911271741.nARHfb220108@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-docs |
Peter Eisentraut wrote:
> On fre, 2009-11-13 at 14:49 -0500, Bruce Momjian wrote:
> > Here is a documentation patch I have applied to clarify that --analyze
> > does analyze during vacuum, not instead of vacuum.
>
> I don't see this committed, but I would vote against it, because the
> wording makes it sound like the statistics are for use by the optimizer
> during vacuum.
I agree with your analysis. I have applied a simpler wording
improvement that just adds the word "Also".
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| Attachment | Content-Type | Size |
|---|---|---|
| /rtmp/diff | text/x-diff | 805 bytes |