Re: TPC-R benchmarks

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Oleg Lebedev <oleg(dot)lebedev(at)waterford(dot)org>, "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: TPC-R benchmarks
Date: 2003-10-01 17:41:59
Message-ID: 200310011041.59348.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Oleg,

> The output of the query should contain about 200 rows. So, I guess the
> planer is off assuming that the query should return 1 row.

Oh, also did you post the query before? Can you re-post it with the planner
results?

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff 2003-10-01 17:42:15 Re: Tuning/performance issue...
Previous Message Josh Berkus 2003-10-01 17:38:53 Re: Ideal Hardware?