Re: TPCH 100GB - need some help - Mailing list pgsql-performance

From Rod Taylor
Subject Re: TPCH 100GB - need some help
Date
Msg-id 1084570822.672.43.camel@jester
Whole thread Raw
In response to TPCH 100GB - need some help  (Eduardo Almeida <edalmeida@yahoo.com>)
List pgsql-performance
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;



pgsql-performance by date:

Previous
From: Eduardo Almeida
Date:
Subject: TPCH 100GB - need some help
Next
From: "Jaime Casanova"
Date:
Subject: numeric data types