Re: Optimize complex join to use where condition before

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Optimize complex join to use where condition before
Date: 2005-05-13 05:56:44
Message-ID: 8764xnoehv.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Sebastian Hennebrueder <usenet(at)laliluna(dot)de> writes:

> User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
> ...
>
> "Nested Loop (cost=1349.13..1435.29 rows=1 width=2541) (actual
> time=1640.000..3687.000 rows=62 loops=1)"
> " Join Filter: ("inner".fid = "outer".faufgaben_id)"
> " -> Index Scan using idx_tauf_mit_mitid on taufgaben_mitarbeiter am
> (cost=0.00..80.65 rows=35 width=4) (actual time=0.000..0.000 rows=765
> loops=1)"

Is it really Mozilla Thunderbird that's causing this new craptastic mangling
of plans in people's mails? I was assuming it was some new idea of how to mess
up people's mail coming out of Exchange or Lotus or some other such "corporate
messaging" software that only handled SMTP mail as an afterthought. This is,
uh, disappointing.

--
greg

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mindaugas Riauba 2005-05-13 12:52:38 PostgreSQL strugling during high load
Previous Message Christopher Browne 2005-05-13 04:16:24 Re: Recommendations for set statistics