Skip site navigation (1) Skip section navigation (2)

Re: Seqscan slowness and stored procedures

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Ivan Voras <ivoras(at)freebsd(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Seqscan slowness and stored procedures
Date: 2012-05-27 16:07:29
Message-ID: (view raw or whole thread)
Lists: pgsql-performance
2012/5/27 Ivan Voras <ivoras(at)freebsd(dot)org>:
> On 27 May 2012 05:28, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
>> Hello
>> 2012/5/26 Ivan Voras <ivoras(at)freebsd(dot)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:
>>> (67 ms)
>>> and this is the plain with enable_seqscan turned off:
>>> (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
> 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,


In response to

pgsql-performance by date

Next:From: Greg SmithDate: 2012-05-28 12:14:05
Subject: Re: SSD selection
Previous:From: Ivan VorasDate: 2012-05-27 15:57:55
Subject: Re: Seqscan slowness and stored procedures

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group