Re: [HACKERS] create index updates nrows statistics

From: ZEUGSWETTER Andreas IZ5 <Andreas(dot)Zeugswetter(at)telecom(dot)at>
To: "'hackers(at)postgresql(dot)org'" <hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] create index updates nrows statistics
Date: 1999-05-27 07:45:21
Message-ID: 219F68D65015D011A8E000006F8590C60267B37D@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 1999-05-27 08:28:11 Re: [HACKERS] NUMERIC regression test?
Previous Message ZEUGSWETTER Andreas IZ5 1999-05-27 07:36:57 Re: [HACKERS] Open 6.5 items