Re: global temporary tables

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: global temporary tables
Дата
Msg-id k2v162867791004241141peb800d6cmb81561a30a8ed5d3@mail.gmail.com
обсуждение исходный текст
Ответ на Re: global temporary tables  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
>
> For a first cut, I had thought about ignoring the problem.  Now, that
> may sound stupid, because now if two different backends have very
> different distributions of data in the table and both do an ANALYZE,
> one set of statistics will clobber the other set of statistics.  On
> the flip side, for some usage patterns, it might be actually work out
> to a win.  Maybe the data I'm putting in here today is a great deal
> like the data I put in here yesterday, and planning it with
> yesterday's statistics doesn't cost enough to be worth a re-ANALYZE.
>

Both variant can be. First time - statistic can be taken from some
"original" (can be empty). After ANALYZE the statistic can be
individual.

Regards
Pavel


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: global temporary tables
Следующее
От: Robert Haas
Дата:
Сообщение: Re: global temporary tables