Re: Seqscan slowness and stored procedures - Mailing list pgsql-performance

From Pavel Stehule
Subject Re: Seqscan slowness and stored procedures
Date
Msg-id CAFj8pRCnJC2oStrgy=w-4o3qtiQ5P6nBnBE=g4rTAngPjPMjxA@mail.gmail.com
Whole thread Raw
In response to Re: Seqscan slowness and stored procedures  (Ivan Voras <ivoras@freebsd.org>)
List pgsql-performance
2012/5/27 Ivan Voras <ivoras@freebsd.org>:
> On 27 May 2012 05:28, Pavel Stehule <pavel.stehule@gmail.com> wrote:
>> Hello
>>
>> 2012/5/26 Ivan Voras <ivoras@freebsd.org>:
>>> Hello,
>>>
>>> I have a SQL function (which I've pasted below) and while testing its
>>> code directly (outside a function), this is the "normal", default plan:
>>>
>>> http://explain.depesz.com/s/vfP (67 ms)
>>>
>>> and this is the plain with enable_seqscan turned off:
>>>
>>> http://explain.depesz.com/s/EFP (27 ms)
>>>
>>> Disabling seqscan results in almost 2.5x faster execution.
>>>
>>> However, when this code is wrapped in a function, the execution time is
>>> closer to the second case (which is great, I'm not complaining):
>>>
>>
>> see http://archives.postgresql.org/pgsql-general/2009-12/msg01189.php
>
> Hi,
>
> Thank you for your answer, but if you read my post, you'll hopefully
> realize my questions are different from that in the linked post, and
> are not answered by the post.

yes, sorry,

Pavel

pgsql-performance by date:

Previous
From: Ivan Voras
Date:
Subject: Re: Seqscan slowness and stored procedures
Next
From: Greg Smith
Date:
Subject: Re: SSD selection