Postgres Pro
Downloads
Home   >   mailing lists

Re: planner not choosing fastest estimated plan - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: planner not choosing fastest estimated plan
Date
Msg-id CAMkU=1w1HZjGkcrCTrMiN+D78XoXxHMjVs5wMvSsibLM_KpDmQ@mail.gmail.com
Whole thread Raw
In response to Re: planner not choosing fastest estimated plan  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Tree view 
On Sat, Jul 6, 2013 at 10:52 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> Hello
>
> pls, can you send EXPLAIN ANALYZE result?

Sure.  I've put them on depesz.  (I don't know how useful it will be,
as I'm worried about the internal inconsistency rather than the actual
run time):

enable_seqscan=on
http://explain.depesz.com/s/8GF

enable_seqscan=off
http://explain.depesz.com/s/51V

Cheers,

Jeff

pgsql-hackers by date:

Previous
From: Szymon Guz
Date:
Subject: Re: [PATCH] Fix conversion for Decimal arguments in plpython functions
Next
From: Tom Lane
Date:
Subject: Re: Run-time posix_fallocate failures