Re: Very poor estimates from planner
От | Rod Taylor |
---|---|
Тема | Re: Very poor estimates from planner |
Дата | |
Msg-id | 1068076006.53233.4.camel@jester обсуждение исходный текст |
Ответ на | Re: Very poor estimates from planner ("scott.marlowe" <scott.marlowe@ihs.com>) |
Ответы |
Re: Very poor estimates from planner
|
Список | pgsql-hackers |
> I'm not sure if that will actually change the default_statistics_target of > the tables you're analyzing, I think it will only apply to newly created > tables. > > I believe you have to alter table alter column set statistics 1000 for > each column you want a statistic of 1000. You might wanna try starting > with 50 or 100 and see if that works first. Hmm.. I was under the impression that it would work for any tables that haven't otherwise been overridden. Sets the default statistics target for table columns that have not had a column-specific target set via ALTERTABLE SET STATISTICS. Larger values increase the time needed to do ANALYZE, but may improve the qualityof the planner's estimates. The default is 10.
В списке pgsql-hackers по дате отправления: