Postgres Pro
Downloads
Home   >   mailing lists

Re: Proposed Query Planner TODO items - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Proposed Query Planner TODO items
Date
Msg-id 10185.1073318430@sss.pgh.pa.us
Whole thread Raw
In response to Proposed Query Planner TODO items  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Proposed Query Planner TODO items  (markw@osdl.org)
Re: Proposed Query Planner TODO items  (Josh Berkus <josh@agliodbs.com>)
Re: Proposed Query Planner TODO items  (markw@osdl.org)
List pgsql-hackers
Tree view 
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.

I've made some progress on this over the last week or two.  Would it be
possible to retry that benchmark with CVS tip?
        regards, tom lane

pgsql-hackers by date:

Previous
From: Eric Ridge
Date:
Subject: Re: Postgres + Xapian (was Re: fulltext searching via a custom index type )
Next
From: "Glenn Wiorek"
Date:
Subject: Re: Announce: Search PostgreSQL related resources