Greg Stark <gsstark(at)mit(dot)edu> wrote:
> your query does require reading all the data.
Huh? It requires reading all the data from at least *one* of the
tables. I could conceivably be faster to read all the data from the
table with 23,980 rows and randomly pick out the necessary 33,768
rows from the table with 33,909,690 rows using the
idx_order_items_order_id index. That seems like it might be faster.
In response to
pgsql-bugs by date
|Next:||From: Raphael Giovanini||Date: 2011-04-01 01:50:34|
|Subject: default password for user postgres|
|Previous:||From: Kris Jurka||Date: 2011-03-31 19:45:43|
|Subject: Re: BUG #5961: JDBC Driver acceptURL does not check 'jdbc:postgresql:'|