On Mon, Aug 12, 2013 at 8:21 AM, Александр Белинский <avinfo79@xxxxxxxxx> wrote: > Hi! > I can't explain why function is slow down on same data. > Postgresql.conf the same, hardware is more powerful. > Diffrents is postgresql version Hmm. PostgreSQL 9.2 will sometimes replan queries a number of times where older releases, looking to see whether the choice of bind variables affects the optimal plan choice, where older versions would create a generic plan on first execution and use it forever. I'm not sure whether that behavior applies in this situation, though. If you run it say 15 times does it eventually start running faster? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
