Re: Different query plans for the same query

2009/9/18 <tv(at)fuzzy(dot)cz>:
>> Hi all,
>>
>> on our PostgreSQL 8.3.1 (CentOS 5.3 64-bit) two different query plans
>> for one of our (weird) queries are generated. One of the query plans
>> seems to be good (and is used most of the time). The other one is bad -
>> the query takes about 2 minutes and the database process, which is
>> executing the query, is cpu bound during this time.
>>
>> After several tries I was able to reproduce the problem when executing
>> the query with EXPLAIN ANALYZE. The bad query plan was generated only
>> seconds after the good one was used when executing the query. What's the
>> reasond for the different query plans? Statistics are up to date.
>>
>> ...
>
> Hi,
>
> please, when posting an explain plan, either save it into a file and
> provide a URL (attachments are not allowed here), or use
> explain.depesz.com or something like that. This wrapping makes the plan
> unreadable so it's much more difficult to help you.

Uh, since when are attachments not allowed here? I completely agree
that line-wrapping is BAD, but I don't agree that pastebin is good. I
would much rather have the relevant material in the email, or in an
attachment, than in some other web site that may or may not format it
readably, may or may not be easy to cut and paste, and will definitely
not become part of our archives.

...Robert