From: | Mark Wong <markw(at)osdl(dot)org> |
---|---|
To: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Proposed Query Planner TODO items |
Date: | 2004-10-25 15:16:08 |
Message-ID: | 20041025081608.A13520@osdl.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi Tatsuo,
Yes, I've been updating the dbt3 kit over the past several months.
The query time graph is a new feature. It's available via BitKeeper
at bk://developer.osdl.org:/var/bk/dbt3 but I haven't tested the kit
well enough to make a v1.5 release yet. If BitKeeper isn't something
you can use, I can make a preliminary tarball for you.
Mark
On Mon, Oct 25, 2004 at 01:59:46PM +0900, Tatsuo Ishii wrote:
> Mark,
>
> I see nice graphs for each DBT3 query(for example,
> http://developer.osdl.org/markw/dbt3-pgsql/42/q_time.png). It seems
> they do not come with normal dbt3-1.4 kit. How did you get them?
> Maybe you have slightly modified dbt3 kit?
> --
> Tatsuo Ishii
>
> > On 6 Feb, To: tgl(at)sss(dot)pgh(dot)pa(dot)us wrote:
> > > On 5 Jan, Tom Lane wrote:
> > >> Josh Berkus <josh(at)agliodbs(dot)com> writes:
> > >>> 2) DEVELOP BETTER PLANS FOR "OR GROUP" QUERIES
> > >>
> > >>> Summary: Currently, queries with complex "or group" criteria get devolved by
> > >>> the planner into canonical and-or filters resulting in very poor execution on
> > >>> large data sets. We should find better ways of dealing with these queries,
> > >>> for example UNIONing.
> > >>
> > >>> Description: While helping OSDL with their derivative TPC-R benchmark, we ran
> > >>> into a query (#19) which took several hours to complete on PostgreSQL.
> >
> > http://developer.osdl.org/markw/dbt3-pgsql/
> >
> > There's a short summary of the tests I ran over the weekend, with links
> > to detailed retults. Comparing runs 43 (7.4) and 52 (7.5devel), it
> > looks like query #7 had the only significant improvement. Oprofile data
> > should be there too, if that'll help. Let us know if there's anything
> > else we can try for you.
> >
> > Mark
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
> >
--
Mark Wong - - markw(at)osdl(dot)org
Open Source Development Lab Inc - A non-profit corporation
12725 SW Millikan Way - Suite 400 - Beaverton, OR 97005
(503) 626-2455 x 32 (office)
(503) 626-2436 (fax)
http://developer.osdl.org/markw/
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2004-10-25 15:31:55 | rmtree() failure on Windows |
Previous Message | Tom Lane | 2004-10-25 14:34:07 | Re: Using ALTER TABLESPACE in pg_dump |