RE: [HACKERS] Some notes on optimizer cost estimates

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема RE: [HACKERS] Some notes on optimizer cost estimates
Дата
Msg-id 001201bf63bb$83adc1a0$2801007e@tpf.co.jp
обсуждение исходный текст
Ответ на Re: [HACKERS] Some notes on optimizer cost estimates  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> 
> > In addition,vacuum error occurs with analyze option in most
> > cases AFAIK. 
> 
> Still, with current sources?  What's the error message?  I fixed
> a problem with pg_statistic tuples getting too big...
>

Sorry,my English is poor.
When I saw vacuum bug reports,there were 'analyze' option mostly.
'Analyze' is harmful for safety of vacuum. 

I'm thinking that 'analyze' is not preferable especially for index
recreation in vacuum. 

Regards.

Hiroshi Inoue
Inoue@tpf.co.jp 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Some notes on optimizer cost estimates
Следующее
От: Thomas Lockhart
Дата:
Сообщение: Re: Date/time type