Re: Guesses on what this NestLoop is for?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Manfred Koizar <mkoi-pg(at)aon(dot)at>
Cc: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Guesses on what this NestLoop is for?
Date: 2003-10-28 17:36:02
Message-ID: 200310280936.02167.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message John K. Herreshoff 2003-10-28 18:06:10 Re: Adding foreign key performance
Previous Message Jeff 2003-10-28 16:33:59 Re: Adding foreign key performance