Re: [PERFORM] Seqscan slowness and stored procedures

2012-05-27 Thread Pavel Stehule
2012/5/27 Ivan Voras : > On 27 May 2012 05:28, Pavel Stehule wrote: >> Hello >> >> 2012/5/26 Ivan Voras : >>> 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.depe

Re: [PERFORM] Seqscan slowness and stored procedures

2012-05-27 Thread Ivan Voras
On 27 May 2012 05:28, Pavel Stehule wrote: > Hello > > 2012/5/26 Ivan Voras : >> 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 thi