Re: Guesses on what this NestLoop is for? - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Guesses on what this NestLoop is for?
Date
Msg-id 200310280936.02167.josh@agliodbs.com
Whole thread Raw
In response to Re: Guesses on what this NestLoop is for?  (Manfred Koizar <mkoi-pg@aon.at>)
List pgsql-performance
Manfred,

> Sorry, I have no answer to your question, but may I ask whether you
> really want to get presumably 106 output rows for each event with
> status 1?
>
> Or did you mean
>      WHERE (events.status = 1 OR events.status = 11) AND ...

Thanks!   I spent so much time tinkering around with the exists clauses, I
completely missed that.   Hopefully I'll get this client to upgrade to 7.4 so
that the explains will be more readable ....

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Jeff
Date:
Subject: Re: Adding foreign key performance
Next
From: markw@osdl.org
Date:
Subject: Re: analyzing postgresql performance for dbt-2