Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3

От

Craig James

Тема

Дата

26 сентября 2011 г. в 14:24:13

Msg-id

4E80B3F9.8070001@emolecules.com

обсуждение

Ответ на

Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 (Tom Lane)

Список

pgsql-performance

Дерево обсуждения

Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Timothy Garnett <tgarnett@panjiva.com> 26 сентября 2011 г. в 12:41:38

Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Tom Lane <tgl@sss.pgh.pa.us> 26 сентября 2011 г. в 14:08:01

Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Craig James <craig_james@emolecules.com> 26 сентября 2011 г. в 14:24:13

Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Tom Lane <tgl@sss.pgh.pa.us> 26 сентября 2011 г. в 14:35:21

Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Craig Ringer <ringerc@ringerc.id.au> 26 сентября 2011 г. в 21:09:52

Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Tom Lane <tgl@sss.pgh.pa.us> 26 сентября 2011 г. в 21:39:36

Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Timothy Garnett <tgarnett@panjiva.com> 27 сентября 2011 г. в 00:19:58

Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Samuel Gendler <sgendler@ideasculptor.com> 27 сентября 2011 г. в 03:14:06

Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Timothy Garnett <tgarnett@panjiva.com> 27 сентября 2011 г. в 13:50:21

Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Timothy Garnett <tgarnett@panjiva.com> 27 сентября 2011 г. в 13:49:59

On 9/26/11 10:07 AM, Tom Lane wrote:
> Cranking up the statistics target for the hts_code_id column (and re-ANALYZEing) ought to fix it. If all your tables are this large you might want to just increase default_statistics_target across the board. regards, tom lane 
This is common advice in this forum ....  but what's the down side to increasing statistics?  With so many questions coming to this forum that are due to insufficient statistics, why not just increase the default_statistics_target?  I assume there is a down side, but I've never seen it discussed.  Does it increase planning time?  Analyze time?  Take lots of space?

Thanks,
Craig

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

Предыдущее

От: Tom Lane

Дата: 26 сентября 2011 г. в 14:08:01

Сообщение: Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3

Следующее

От: Tom Lane

Дата: 26 сентября 2011 г. в 14:35:21

Сообщение: Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3