Skip site navigation (1) Skip section navigation (2)

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joseph Shraibman <jks(at)selectacast(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: why can't 2 indexes be used at once?
Date: 2004-04-30 03:57:49
Message-ID: 20259.1083297469@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Joseph Shraibman <jks(at)selectacast(dot)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

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2004-04-30 04:30:26
Subject: Re: Insert only tables and vacuum performance
Previous:From: Joseph ShraibmanDate: 2004-04-30 00:53:21
Subject: Re: Insert only tables and vacuum performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group