From: | Oleg Lebedev <oleg(dot)lebedev(at)waterford(dot)org> |
---|---|
To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: TPC-R benchmarks |
Date: | 2003-10-01 17:29:21 |
Message-ID: | 993DBE5B4D02194382EC8DF8554A52731D7615@postoffice.waterford.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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.
I will start EXPLAIN ANALYZE now.
Thanks.
Oleg
-----Original Message-----
From: scott.marlowe [mailto:scott(dot)marlowe(at)ihs(dot)com]
Sent: Wednesday, October 01, 2003 7:23 AM
To: Oleg Lebedev
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] TPC-R benchmarks
On Tue, 30 Sep 2003, Oleg Lebedev wrote:
> 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. Thanks.
What are the differences between estimated and real rows and such of an
explain analyze on that query? Are there any estimates that are just
way
off?
*************************************
This e-mail may contain privileged or confidential material intended for the named recipient only.
If you are not the named recipient, delete this message and all attachments.
Unauthorized reviewing, copying, printing, disclosing, or otherwise using information in this e-mail is prohibited.
We reserve the right to monitor e-mail sent through our network.
*************************************
From | Date | Subject | |
---|---|---|---|
Next Message | Dimitri Nagiev | 2003-10-01 17:30:47 | Optimizing >= and <= for numbers and dates |
Previous Message | Tom Lane | 2003-10-01 17:14:21 | Re: Joins on inherited tables |