Re: vacuum locking

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Rob Nagler <nagler(at)bivio(dot)biz>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: vacuum locking
Date: 2003-10-30 17:55:32
Message-ID: Pine.LNX.4.33.0310301054360.23412-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, 30 Oct 2003, Rob Nagler wrote:

> scott.marlowe writes:
> > t2 was 'vacuum full'ed and analyzed, right? Just guessing.
>
> Fresh import. I've been told this includes a ANALYZE.

You should probably run analyze by hand just to be sure. If the planner
is using an index scan on a table with 20 rows, then it's likely it has
the default statistics for the table, not real ones.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Stark 2003-10-30 18:18:05 Re: Query puts 7.3.4 on endless loop but 7.4beta5 is fine.
Previous Message Tom Lane 2003-10-30 17:28:47 Re: vacuum locking