Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL does CAST implicitely between int and a domain derived from int - Mailing list pgsql-performance

From Tom Lane
Subject Re: PostgreSQL does CAST implicitely between int and a domain derived from int
Date
Msg-id 18938.1251396313@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL does CAST implicitely between int and a domain derived from int  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: PostgreSQL does CAST implicitely between int and a domain derived from int
List pgsql-performance
Tree view 
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 by date:

Previous
From: Robert Haas
Date:
Subject: Re: PostgreSQL does CAST implicitely between int and a domain derived from int
Next
From: gael@pilotsystems.net (Gaël Le Mignot)
Date:
Subject: Re: Performance regression between 8.3 and 8.4 on heavy text indexing