Oleg,
> 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.
Even though it takes hours to complete, I think we need you to run EXPLAIN
ANALYZE instead of just EXPLAIN. Without the real-time statistics, we
simply can't see what's slowing the query down.
--
Josh Berkus
Aglio Database Solutions
San Francisco