| From: | Doug McNaught <doug(at)wireboard(dot)com> |
|---|---|
| To: | Thomas Beutin <tyrone(at)laokoon(dot)IN-Berlin(dot)DE> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Wierd Explain |
| Date: | 2002-06-18 14:39:00 |
| Message-ID: | m31yb48xdn.fsf@varsoon.wireboard.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thomas Beutin <tyrone(at)laokoon(dot)IN-Berlin(dot)DE> writes:
> Hi,
>
> On Tue, Jun 18, 2002 at 12:33:26PM +0530, Varun Kacholia wrote:
> > hi ,
> > Many ppl have suggested me vaccum analyze .
> > But the manuals say me that it is reqd after "major update/deletion".
> > I have just 'created' the tables and done fresh insertions.
> > is it still required?
> AFAIK is not.
The 'analyze' part is needed since otherwise there will not be
accurate statistics about the table data, which can lead to bad choice
of query plans.
In 7.1.3 you can't do 'analyze' on its own, so you need to do 'vacuum
analyze'.
-Doug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Henrik Steffen | 2002-06-18 14:47:03 | Re: Serious Crash last Friday |
| Previous Message | Andrew Sullivan | 2002-06-18 14:37:13 | Re: number of registers of a table |