Re: Hypothetical suggestions for planner, indexing improvement - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Hypothetical suggestions for planner, indexing improvement
Date
Msg-id 200305060817.51575.josh@agliodbs.com
Whole thread Raw
In response to Re: Hypothetical suggestions for planner, indexing improvement  ("Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>)
List pgsql-hackers
Andreas,

> PS: in the example the subselect join clause event_id=events.event_id is
> missing

Sorry.  I was cutting-and-pasting to reduce the complexity of the query.   The
full query is actually posted on -PERFORMANCE, as is a workaround to the
"exists selectivity problem".

--
Josh Berkus
Aglio Database Solutions
San Francisco



pgsql-hackers by date:

Previous
From: Andreas Pflug
Date:
Subject: contribute pg_get_viewdef2 et al
Next
From: Steve Crawford
Date:
Subject: Re: 7.4 features list