On Fri, 2004-05-14 at 14:00, Eduardo Almeida wrote:
> Hi folks,
> 
> I need some help in a TPCH 100GB benchmark.

Performance with 7.5 is much improved over 7.4 for TPCH due to efforts
of Tom Lane and OSDL. Give it a try with a recent snapshot of
PostgreSQL.

Otherwise, disable nested loops for that query. 

        set enable_nestloop = off;



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to