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(at)laokoon(dot)IN-Berlin(dot)DE
Beam me up, Scotty. There is no intelligent live down in Redmond.