Re: Postgres-7.0.2 optimization question

From: "Steve Wolfe" <steve(at)iboats(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres-7.0.2 optimization question
Date: 2000-10-13 15:23:06
Message-ID: 00fe01c03529$81c9ef40$50824e40@iboats.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Fri, Oct 13, 2000 at 02:05:18PM +0200, Igor V. Rafienko wrote:
> > I tried vacuumdb --analyze. It did not help. I tried creating an index
on
>
> If I parse right this is excactly VACUUM without ANALYZE
> because '--' is SQL comment start ... no?

"vacuumdb" is invoked at the shell, not in an SQL editor, so "--analyze"
is just an argument passed to the vacuumdb program, causing it to analyze as
it vacuums. "vacuumdb --help" tells you all of the nifty arguments. : )

steve

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Horst Herb 2000-10-13 15:23:14 Re: Binary Cursors
Previous Message Nico D 2000-10-13 15:20:44 Referential integrity and inheritance.