ALTER TABLE .. SET STATISTICS

Поиск
Список
Период
Сортировка
От Ron
Тема ALTER TABLE .. SET STATISTICS
Дата
Msg-id 45407d90-85dc-f5ba-58a5-d07fe99e852a@gmail.com
обсуждение исходный текст
Ответы Re: ALTER TABLE .. SET STATISTICS
Re: ALTER TABLE .. SET STATISTICS
Список pgsql-general
v9.6.9

For columns of type bytea which store image data (PDFs, JPGs, etc) would it 
speed up the ANALYZE process to SET STATISTICS = 0?

That way, default_statistics_target could be cranked higher -- giving better 
statistics for needed columns -- without polluting pg_statistics with 
unneeded data?

Thanks

-- 
Angular momentum makes the world go 'round.


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