Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VAJ8a-0007wd-Gq for pgsql-performance@arkaria.postgresql.org; Fri, 16 Aug 2013 12:28:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VAJ8Z-0002pI-NZ for pgsql-performance@arkaria.postgresql.org; Fri, 16 Aug 2013 12:28:15 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VAJ8Y-0002pC-Ss for pgsql-performance@postgresql.org; Fri, 16 Aug 2013 12:28:15 +0000 Received: from mail-lb0-x229.google.com ([2a00:1450:4010:c04::229]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VAJ8W-0004ji-56 for pgsql-performance@postgresql.org; Fri, 16 Aug 2013 12:28:14 +0000 Received: by mail-lb0-f169.google.com with SMTP id u10so1451943lbi.28 for ; Fri, 16 Aug 2013 05:28:10 -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:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; bh=dZiknCCUqDvheQr9Yzt4NbpVwJfJ83vUhhnxWycnwlg=; b=ol9HwGmY1Aj6PXYTJwsBd4fWn+zmjAwn4Y5oTDBF6cPNerBURaNPvWTPwuoCxULKT6 c46RRuXbVVzdvn9r46ZvSOS+1L1qYjfEFIHWj4jbEGHq+TPcvmzogJ+rO4OWeMVVeYAK 0Cn8KGN4RoG07VJLtzYjSFpkuPhOj+nspJYDs2oiJSm0RHLPqn1W/ew/fVKW04m8vFz7 gtXp71TAPoOcdCkmoo+856wz+81FuWgmGb93M/xhcL4d+3pMncDiMnxiRf7rJ5r2701D WGb5POLOlYWMDtR9rJiCANArC8KB+VzyCOvcHrqDpYBsCVZ5y98mr+K5tWKcgfDq+Cju gPHw== X-Received: by 10.112.52.225 with SMTP id w1mr1653775lbo.31.1376656090469; Fri, 16 Aug 2013 05:28:10 -0700 (PDT) Received: from [192.168.3.104] ([109.254.92.251]) by mx.google.com with ESMTPSA id ay4sm925758lbb.2.1969.12.31.16.00.00 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Fri, 16 Aug 2013 05:28:09 -0700 (PDT) Message-ID: <520E1ABB.1000308@gmail.com> Date: Fri, 16 Aug 2013 15:27:39 +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: Pavel Stehule CC: pgsql-performance@postgresql.org Subject: Re: Function execute slow down in 9.2 References: <5208F85F.50706@gmail.com> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: 2.1 (++) 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 12.08.2013 18:24, Pavel Stehule пишет: > Hello > > it looks like known issue of sometimes dysfunctional plan cache in > plpgsql in 9.2. > > similar issuehttp://postgresql.1045698.n5.nabble.com/Performance-problem-in-PLPgSQL-td5764796.html Thanks for the link ) I read about issue, but I can't understand what should I do? i chage values of seq_page_cost =1.0 =10.0 = 100.0 = 0.1 =0.01 but nothing chage, time of function execution the same. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance