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
pgsql-performance by date
|Next:||From: Gaël Le Mignot||Date: 2009-08-27 20:03:10|
|Subject: Re: Performance regression between 8.3 and 8.4 on heavy text indexing|
|Previous:||From: Robert Haas||Date: 2009-08-27 17:35:02|
|Subject: Re: PostgreSQL does CAST implicitely between int and a domain derived from int|