| From: | "Igor V(dot) Rafienko" <igorr(at)ifi(dot)uio(dot)no> |
|---|---|
| To: | |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Postgres-7.0.2 optimization question |
| Date: | 2000-10-13 15:25:04 |
| Message-ID: | Pine.SOL.4.21.0010131720160.24891-100000@vigrid.ifi.uio.no |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
on Oct 13, 2000, 17:26, Marko Kreen std::cout'ed:
| 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?
Ehh... no. Not quite:
$ ./vacuumdb --help | grep analyze
vacuumdb cleans and analyzes a PostgreSQL database.
-z, --analyze Update optimizer hints
$
The analyze was performed from outside the database via vacuumdb command,
not via VACUUM command in the psql.
ivr
--
Everybody has to have a philosophy. Some people believe in laissez
faire economics, others believe in reincarnation. Some people even
believe that COBOL is a real programming language.
S. Meyers, "Effective C++", item 26
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marko Kreen | 2000-10-13 15:26:21 | Re: Postgres-7.0.2 optimization question |
| Previous Message | Horst Herb | 2000-10-13 15:23:14 | Re: Binary Cursors |