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  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Ari Halberstadt
Дата:
Сообщение: pg_dump core dump, upgrading from 6.5b1 to 5/24 snapshot
Следующее
От: Vadim Mikheev
Дата:
Сообщение: Re: [HACKERS] ERROR: WaitOnLock: error on wakeup - Aborting this transaction