Re: Allow vacuumdb to only analyze

Jaime Casanova wrote:
> On Thu, Feb 25, 2010 at 5:09 PM, Bruce Momjian <bruce@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  <bruce@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"));