Re: Hypothetical suggestions for planner, indexing improvement

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Hypothetical suggestions for planner, indexing improvement
Date: 2003-05-06 15:17:51
Message-ID: 200305060817.51575.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Steve Crawford 2003-05-06 15:32:18 Re: 7.4 features list
Previous Message Andreas Pflug 2003-05-06 15:17:08 contribute pg_get_viewdef2 et al