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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-performance(at)postgresql(dot)org, Jean-Michel Pouré <jm(at)poure(dot)com>
Subject: Re: PostgreSQL does CAST implicitely between int and a domain derived from int
Date: 2009-08-27 18:05:13
Message-ID: 18938.1251396313@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Robert Haas <robertmhaas(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Gaël Le Mignot 2009-08-27 20:03:10 Re: Performance regression between 8.3 and 8.4 on heavy text indexing
Previous Message Robert Haas 2009-08-27 17:35:02 Re: PostgreSQL does CAST implicitely between int and a domain derived from int