Mr. Tom Lane
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Eduardo Almeida <[EMAIL PROTECTED]> writes:
> > I need some help in a TPCH 100GB benchmark.
> > Here I put the query #19, the explain and the
> "top"
> > for it.
>
> IIRC, this is one of the cases that inspired the
> work that's been done
>
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 tha
Hi folks,
I need some help in a TPCH 100GB benchmark.
I described our settings in:
http://archives.postgresql.org/pgsql-performance/2004-04/msg00377.php
Some queries are taking to long to finish (4, 8, 9,
10, 19,20 and 22) and I need some help to increase the
system performance.
Here I put the q
