Re: create index updates nrows statistics
| От | ZEUGSWETTER Andreas IZ5 |
|---|---|
| Тема | Re: create index updates nrows statistics |
| Дата | |
| Msg-id | 219F68D65015D011A8E000006F8590C60267B376@sdexcsrv1.f000.d0188.sd.spardat.at обсуждение исходный текст |
| Ответ на | create index updates nrows statistics (ZEUGSWETTER Andreas IZ5 <Andreas.Zeugswetter@telecom.at>) |
| Ответы |
Re: [HACKERS] Re: create index updates nrows statistics
|
| Список | pgsql-hackers |
> a create index updates the statistics in pg_class, > this leads to substantial performance degradation compared to > 6.4.2. > > If you want to see what I mean simply run the performance test in > our test subdirectory. > > I think the create index statement should not update this statistic. > (at least not in the newly created empty table case) > This behavior would then be in sync with the create table behavior. > To fix this I urgently suggest the following patch:<<index.patch>> regression passes and is a little faster :-) performance test: without patch 7min now 22 sec Andreas
В списке pgsql-hackers по дате отправления: