From: | Craig Longman <craigl(at)begeek(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: strange plan |
Date: | 2001-06-27 05:45:35 |
Message-ID: | 993620736.6508.13.camel@jigra.begeek.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-sql |
On 27 Jun 2001 01:28:03 -0400, Craig Longman wrote:
>
> i've got two machines both with roughly the same database, one has a few
> more rows in some of the tables, but only about 2% more. both databases
> have the same tables and the same indexes. however, the slower machine
> seemed to be much slower than i would have expected it to be, so i
> started doing some looking, and found some very different and strange
> query plans.
i'm sorry. i had been under the mistaken impression that the vacuumdb
command updated the table/index statistics. i returned to looking
through the manual after sending the email and almost immediately
stumbled upon the 'vacuum analyze' command. sigh. it optimizes as
expected now and returns in a proportionate amount of time.
humbly,
--
CraigL->Thx();
Be Developer ID: 5852
From | Date | Subject | |
---|---|---|---|
Next Message | Subra Radhakrishnan | 2001-06-27 06:42:27 | |
Previous Message | Craig Longman | 2001-06-27 05:28:03 | strange plan |
From | Date | Subject | |
---|---|---|---|
Next Message | Jie Liang | 2001-06-27 06:57:06 | session detect and terminate |
Previous Message | Craig Longman | 2001-06-27 05:28:03 | strange plan |