Horton

Re: Wierd Explain

scott.marlowe <scott.marlowe@ihs.com>

View thread View on postgr.es
From: Scott Marlowe <scott.marlowe@ihs.com>
To: Thomas Beutin <tyrone@laokoon.in-berlin.de>
Cc: <pgsql-general@postgresql.org>
Date: 2002-06-18T15:03:50Z
Lists: pgsql-general 
On Tue, 18 Jun 2002, Thomas Beutin wrote:

> 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.

Actually, you do have to run it then.  Analyze is never done automatically 
by Postgresql, so the postmaster has no idea how your data are organized 
yet.  (Varun's data, not Thomas's  :-)

Scott Marlowe