Re: More thoughts about planner's cost estimates

Поиск
Список
Период
Сортировка
От Todd A. Cook
Тема Re: More thoughts about planner's cost estimates
Дата
Msg-id 4480BAA1.9040907@blackducksoftware.com
обсуждение исходный текст
Ответ на Re: More thoughts about planner's cost estimates  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: More thoughts about planner's cost estimates  (Jim Nasby <jnasby@pervasive.com>)
Список pgsql-hackers
Josh Berkus wrote:
> Greg, Tom,
> 
>> But for most users analyze doesn't really have to run as often as
>> vacuum. One sequential scan per night doesn't seem like that big a deal
>> to me.
> 
> Clearly you don't have any 0.5 TB databases.  

Perhaps something like "ANALYZE FULL"?  Then only those who need the
more precise statistics would pay the cost for a full scan.

-- todd


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: More thoughts about planner's cost estimates
Следующее
От: "Mark Woodward"
Дата:
Сообщение: Re: COPY (query) TO file