Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V8tbb-0004D6-2G for pgsql-performance@arkaria.postgresql.org; Mon, 12 Aug 2013 15:00:23 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1V8tba-0005Vx-In for pgsql-performance@arkaria.postgresql.org; Mon, 12 Aug 2013 15:00:22 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V8tbZ-0005Vq-Ba for pgsql-performance@postgresql.org; Mon, 12 Aug 2013 15:00:21 +0000 Received: from mail-lb0-x236.google.com ([2a00:1450:4010:c04::236]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V8tbS-0006Sg-Ow for pgsql-performance@postgresql.org; Mon, 12 Aug 2013 15:00:20 +0000 Received: by mail-lb0-f182.google.com with SMTP id v20so4931376lbc.13 for ; Mon, 12 Aug 2013 08:00:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:subject :content-type:content-transfer-encoding; bh=b4FqIvxsV9gGL1yqqq/m+SW/dzJ1BT6Flodor9RObtM=; b=LDs8teRsLixa6p3RhRmdSBgsIuv+2OvsS18GSa3P9Ag57fn7TJO9UYaAXgIMFAlmo2 aRwLxjV37cqcjrmp7x60NjVli9plVK33TUMW0oneOpOgkSdvL8HRTo11MsT/1uJ0fXvA QNBOpkeBkFv5roAy+xzL41DoSQshwuvgdIMMxGXx31+JLrK8Rk9kBG2ovTmjV5eEfAGW ZyVghmE/ICwga0ZTV5oMGg1dCvIG9fu9+R6YHLxjqutkYe+evpyS/V1ZLTz8EAxea3Pj DDroUtnLaL9Kc4Xt7Wsp74jnc+x7jVOFkFxzI0xhIBvz9ZBSv7OSTk2PV0kwHfkj0MOa TqHw== X-Received: by 10.112.0.242 with SMTP id 18mr2856660lbh.18.1376319611922; Mon, 12 Aug 2013 08:00:11 -0700 (PDT) Received: from [192.168.3.104] ([109.254.92.251]) by mx.google.com with ESMTPSA id d9sm9556727lbf.2.2013.08.12.08.00.09 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Mon, 12 Aug 2013 08:00:10 -0700 (PDT) Message-ID: <5208F85F.50706@gmail.com> Date: Mon, 12 Aug 2013 17:59:43 +0300 From: =?UTF-8?B?0JDQu9C10LrRgdCw0L3QtNGAINCR0LXQu9C40L3RgdC60LjQuQ==?= User-Agent: Mozilla/5.0 (X11; Linux i686; rv:17.0) Gecko/20130801 Thunderbird/17.0.8 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Function execute slow down in 9.2 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: 0.9 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org 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 Here it;s my tests Server 1 PSQL 9.1 FIRST RUN EXPLAIN (ANALYZE, BUFFERS) SELECT webclient.prc_ti_cache_alloc_dbl_update( 21325134 ); 'Result (cost=0.00..0.26 rows=1 width=0) (actual time=1399.586..1399.587 rows=1 loops=1)' ' Buffers: shared hit=40343 read=621' 'Total runtime: 1399.613 ms' SECOND RUN 'Result (cost=0.00..0.26 rows=1 width=0) (actual time=42.540..42.541 rows=1 loops=1)' ' Buffers: shared hit=37069' 'Total runtime: 42.558 ms' THIRD RUN 'Result (cost=0.00..0.26 rows=1 width=0) (actual time=198.893..198.894 rows=1 loops=1)' ' Buffers: shared hit=37069' 'Total runtime: 198.908 ms' Server 2 PSQL 9.2 FIRST RUN EXPLAIN (ANALYZE, BUFFERS) SELECT webclient.prc_ti_cache_alloc_dbl_update( 21325134 ); 'Result (cost=0.00..0.26 rows=1 width=0) (actual time=1328.103..1328.104 rows=1 loops=1)' ' Buffers: shared hit=43081 read=233 written=36' 'Total runtime: 1328.129 ms' SECOND RUN 'Result (cost=0.00..0.26 rows=1 width=0) (actual time=1699.711..1699.712 rows=1 loops=1)' ' Buffers: shared hit=42919' 'Total runtime: 1699.737 ms' THIRD RUN 'Result (cost=0.00..0.26 rows=1 width=0) (actual time=1907.947..1907.948 rows=1 loops=1)' ' Buffers: shared hit=42869' 'Total runtime: 1907.965 ms' -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance