Message-ID: <4284F2CA.1070107@arbash-meinel.com>
Date: Fri, 13 May 2005 13:32:42 -0500
From: John A Meinel <john@arbash-meinel.com>
User-Agent: Mozilla Thunderbird 1.0.2-1.3.2 (X11/20050324)
MIME-Version: 1.0
To: Greg Stark <gsstark@mit.edu>
Cc: pgsql-performance@postgresql.org
Subject: Re: Optimize complex join to use where condition before
References: <4283D985.4080908@laliluna.de> <428414DE.8030904@laliluna.de>
	<8764xnoehv.fsf@stark.xeocode.com>
In-Reply-To: <8764xnoehv.fsf@stark.xeocode.com>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="------------enigC04E1A06AA0EDCE529417086"

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enigC04E1A06AA0EDCE529417086
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Greg Stark wrote:
> 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.
>

Are you talking about the quotes, or just the fact that it is wrapped?

I don't know where the quotes came from, but in Thunderbird if you are
writing in text mode (not html) it defaults to wrapping the text at
something like 78 characters. That includes copy/paste text.

If you want it to *not* wrap, it turns out that "Paste as quotation"
will not wrap, but then you have to remove the "> " from the beginning
of every line.

In html mode, it also defaults to wrapping, but if you switch to
PREFORMAT text first, it doesn't wrap.

At least, those are the tricks that I've found. Safest bet is to just
use an attachment, though.

John
=:->


--------------enigC04E1A06AA0EDCE529417086
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFChPLKJdeBCYSNAAMRAseEAJ4zToMRzPIGLbEjdwhavYn6m/nUlwCffOEQ
87d8L6vPhq1MGMg4mhyfEwE=
=AoYd
-----END PGP SIGNATURE-----

--------------enigC04E1A06AA0EDCE529417086--