Postgres Pro
Downloads
Home   >   mailing lists

Re: why can't 2 indexes be used at once? - Mailing list pgsql-performance

From Tom Lane
Subject Re: why can't 2 indexes be used at once?
Date
Msg-id 20259.1083297469@sss.pgh.pa.us
Whole thread Raw
In response to why can't 2 indexes be used at once?  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Joseph Shraibman
Date:
Subject: Re: Insert only tables and vacuum performance
Next
From: Tom Lane
Date:
Subject: Re: Insert only tables and vacuum performance