Re: Better estimates of index correlation

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Better estimates of index correlation
Дата
Msg-id 1300112623-sup-7438@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Better estimates of index correlation  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Better estimates of index correlation  (Robert Haas <robertmhaas@gmail.com>)
Re: Better estimates of index correlation  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Excerpts from Robert Haas's message of lun mar 14 11:18:24 -0300 2011:
> On Mon, Mar 14, 2011 at 10:09 AM, Alvaro Herrera
> <alvherre@commandprompt.com> wrote:

> > It sure would be nice to be able to do it only during the last scan.
> 
> Does it really matter?  What Tom was describing sounded embarassingly cheap.

Well, you only do multiple passes for tables that are really large, so
it's precisely there that you want to save the extra overhead of having
to do it multiple times.

As Heikki says, maybe this wouldn't be an issue at all if we can do it
during ANALYZE instead, but I don't know if that works.

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Shared invalidation cache messages for temporary tables
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Shared invalidation cache messages for temporary tables