Re: [HACKERS] create index updates nrows statistics - Mailing list pgsql-hackers

From ZEUGSWETTER Andreas IZ5
Subject Re: [HACKERS] create index updates nrows statistics
Date
Msg-id 219F68D65015D011A8E000006F8590C60267B37D@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List pgsql-hackers
> I believe 6.5 is operating as it should --- 6.4 was producing inferior
> plans for small tables.
> 
Yes, absolutely.

> But it is clearly a Bad Thing to allow the 6.5
> optimizer to believe that a relation is empty when it isn't.  I concur
> with your suggestion to hack up CREATE INDEX so that creating an index
> before you load the table isn't quite such a losing proposition.
> 
> > Please apply the patch I previously sent.
> 
> Will do.
> 
I think this will save us a lot of complaints. Thanx

Andreas


pgsql-hackers by date:

Previous
From: ZEUGSWETTER Andreas IZ5
Date:
Subject: Re: [HACKERS] Open 6.5 items
Next
From: wieck@debis.com (Jan Wieck)
Date:
Subject: Re: [HACKERS] NUMERIC regression test?