Horton

Re: why can't 2 indexes be used at once?

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Joseph Shraibman <jks@selectacast.net>
Cc: pgsql-performance@postgresql.org
Date: 2004-04-30T03:57:49Z
Lists: pgsql-performance 
Joseph Shraibman <jks@selectacast.net> writes:
> My question: why can't it go through the first index, get a list of 
> pages in the table, then go through the second index, union the result 
> with the results from first index, and then go into the table?

See TODO list ...

			regards, tom lane