RE: [HACKERS] Some notes on optimizer cost estimates - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject RE: [HACKERS] Some notes on optimizer cost estimates
Date
Msg-id 001201bf63bb$83adc1a0$2801007e@tpf.co.jp
Whole thread Raw
In response to Re: [HACKERS] Some notes on optimizer cost estimates  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Some notes on optimizer cost estimates
Next
From: Thomas Lockhart
Date:
Subject: Re: Date/time type