Re: seq scan instead of index scan - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: seq scan instead of index scan
Date
Msg-id dcc563d10912171737g6a0e6e5em43dafe34d32e1fcd@mail.gmail.com
Whole thread Raw
In response to Re: seq scan instead of index scan  (Karl Larsson <karl.larsson47@gmail.com>)
List pgsql-performance
On Thu, Dec 17, 2009 at 6:17 PM, Karl Larsson <karl.larsson47@gmail.com> wrote:
>> Best bet is to post the real problem, not a semi-representational made
>> up one.  Unless the made up "test case" is truly representative and
>>  recreates the failure pretty much the same was as the original.
>
> I agree at some level but I generally believe other people won't read
> a big mail like that. In this case it might come to a big post from me
> one day soon. :-)

You're on the one mailing list where they will read big posts.  It's
best if you can attach the explain analyze output as an attachment
tho, to keep it's format readable.

pgsql-performance by date:

Previous
From: Karl Larsson
Date:
Subject: Re: seq scan instead of index scan
Next
From: Craig Ringer
Date:
Subject: Re: Automatic optimization of IN clauses via INNER JOIN