Re: Review remove {join,from}_collapse_limit, add enable_join_ordering - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Review remove {join,from}_collapse_limit, add enable_join_ordering
Date
Msg-id 200907161525.34304.andres@anarazel.de
Whole thread Raw
In response to Re: Review remove {join,from}_collapse_limit, add enable_join_ordering  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
On Thursday 16 July 2009 15:18:01 Andres Freund wrote:
> On Thursday 16 July 2009 15:13:02 Tom Lane wrote:
> > Andres Freund <andres@anarazel.de> writes:
> > > The queries on the second reporting schema unfortunately are different.
> > > Its the one were I copied the crazy example I attached in the original
> > > thread. With geqo=off a good part of the queries used daily use too
> > > much memory to plan sensibly and geqo=on outright fails with:
> > > "Error: Failed to make a valid plan"
> > > on some.
> >
> > We're not going to be able to fix this unless you show us examples.
>
> In the other thread I attached a similar to the real schema + example
> query. Not enough? And why?
For reference:
http://archives.postgresql.org/message-
id/200907091700.43411.andres@anarazel.de

Andres


pgsql-hackers by date:

Previous
From: Grzegorz Jaskiewicz
Date:
Subject: Re: boolean in C
Next
From: Tom Lane
Date:
Subject: Re: boolean in C