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