From: Greg Stark <gsstark@mit.edu>
To: pgsql-performance@postgresql.org
Subject: Re: Optimize complex join to use where condition before
Date: 13 May 2005 01:56:44 -0400
Message-ID: <8764xnoehv.fsf@stark.xeocode.com> (raw)
In-Reply-To: <428414DE.8030904@laliluna.de>
References: <4283D985.4080908@laliluna.de>
<428414DE.8030904@laliluna.de>
Sebastian Hennebrueder <usenet@laliluna.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gsstark@mit.edu
Subject: Re: Optimize complex join to use where condition before
In-Reply-To: <8764xnoehv.fsf@stark.xeocode.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox