Mario Splivalo <mario.spliv...@megafon.hr> writes: > Is this difference normal?
It's hard to tell, because you aren't comparing apples to apples. Try a prepared statement, like prepare foo(int) as SELECT COUNT(*)::int4 FROM _v1 WHERE service_id = $1 ; execute foo(504); which should produce results similar to the function. You could then use "explain analyze execute" to probe further into what's happening. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance