Re: Proposed Query Planner TODO items

Поиск
Список
Период
Сортировка
От Tatsuo Ishii
Тема Re: Proposed Query Planner TODO items
Дата
Msg-id 20041026.124449.13773317.t-ishii@sra.co.jp
обсуждение исходный текст
Ответ на Re: Proposed Query Planner TODO items  (Mark Wong <markw@osdl.org>)
Ответы Re: Proposed Query Planner TODO items  (Mark Wong <markw@osdl.org>)
Список pgsql-hackers
Hi,

Thanks for the info. Would you give me the tarball?
--
Tatsuo Ishii

> 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@sss.pgh.pa.us wrote:
> > > > On  5 Jan, Tom Lane wrote:
> > > >> Josh Berkus <josh@agliodbs.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@postgresql.org)
> > > 
> 
> -- 
> Mark Wong - - markw@osdl.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/
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
> 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: timestamp with time zone a la sql99
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Using ALTER TABLESPACE in pg_dump