Re: PostgreSQL does CAST implicitely between int and a domain derived from int

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PostgreSQL does CAST implicitely between int and a domain derived from int
Дата
Msg-id 18938.1251396313@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PostgreSQL does CAST implicitely between int and a domain derived from int  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: PostgreSQL does CAST implicitely between int and a domain derived from int
Список pgsql-performance
Robert Haas <robertmhaas@gmail.com> writes:
> By the way, why does EXPLAIN not display the name of the table as well
> as the index when it performs a bitmap index scan?

Because that plan node is not in fact touching the table.  The table
name is shown in the BitmapHeapScan node that *does* touch the table.

            regards, tom lane

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: PostgreSQL does CAST implicitely between int and a domain derived from int
Следующее
От: gael@pilotsystems.net (Gaël Le Mignot)
Дата:
Сообщение: Re: Performance regression between 8.3 and 8.4 on heavy text indexing