Jaime Casanova wrote:
> On Thu, Feb 25, 2010 at 5:09 PM, Bruce Momjian <br...@momjian.us> wrote:
> >
> > This is implemented in 9.0 from vacuumdb:
> >
> > ? ? ? ? ?-Z, --analyze-only ? ? ? ? ? ? ?only update optimizer hints
> >
>
> maybe just noise, but it's not better to say "optimizer statistics"
> instead of "optimizer hints"?
Wow, I never noticed that but --analyze used "hints" too, and in 8.4 as
well. I have updated it to call it "statistics" in the attached patch.
The manual page does not call them hints.
--
Bruce Momjian <br...@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do
+ If your life is a hard drive, Christ can be your backup. +
Index: src/bin/scripts/vacuumdb.c
===================================================================
RCS file: /cvsroot/pgsql/src/bin/scripts/vacuumdb.c,v
retrieving revision 1.36
diff -c -c -r1.36 vacuumdb.c
*** src/bin/scripts/vacuumdb.c 26 Feb 2010 02:01:20 -0000 1.36
--- src/bin/scripts/vacuumdb.c 26 Feb 2010 04:13:42 -0000
***************
*** 336,343 ****
printf(_(" -q, --quiet don't write any messages\n"));
printf(_(" -t, --table='TABLE[(COLUMNS)]' vacuum specific table only\n"));
printf(_(" -v, --verbose write a lot of output\n"));
! printf(_(" -z, --analyze update optimizer hints\n"));
! printf(_(" -Z, --analyze-only only update optimizer hints\n"));
printf(_(" --help show this help, then exit\n"));
printf(_(" --version output version information, then exit\n"));
printf(_("\nConnection options:\n"));
--- 336,343 ----
printf(_(" -q, --quiet don't write any messages\n"));
printf(_(" -t, --table='TABLE[(COLUMNS)]' vacuum specific table only\n"));
printf(_(" -v, --verbose write a lot of output\n"));
! printf(_(" -z, --analyze update optimizer statistics\n"));
! printf(_(" -Z, --analyze-only only update optimizer statistics\n"));
printf(_(" --help show this help, then exit\n"));
printf(_(" --version output version information, then exit\n"));
printf(_("\nConnection options:\n"));
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
