Re: Wierd Explain

Hi,

On Tue, Jun 18, 2002 at 09:03:50AM -0600, Scott Marlowe wrote:
> On Tue, 18 Jun 2002, Thomas Beutin wrote:
> > On Tue, Jun 18, 2002 at 12:33:26PM +0530, Varun Kacholia wrote:
> > >   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  :-)

Sorry, i forgot the postings bevor. But correct me if i'm wrong:
Creating a fresh table an inserting data. For the data retreiving
the vacuum analyze is not neccessary, but to get correct values
by explain it is required. Right?

Greetings.
-tb
-- 
Thomas Beutin                             tb@laokoon.IN-Berlin.DE
Beam me up, Scotty. There is no intelligent live down in Redmond.