On Tue, 30 Sep 2003, Oleg Lebedev wrote:

> I continue struggling with the TPC-R benchmarks and wonder if anyone
> could help me optimize the query below. ANALYZE statistics indicate that
> the query should run relatively fast, but it takes hours to complete. I
> attached the query plan to this posting.
> Thanks.

What are the differences between estimated and real rows and such of an 
explain analyze on that query?  Are there any estimates that are just way 

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to