Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XJVEe-0004rO-4o for pgsql-sql@arkaria.postgresql.org; Mon, 18 Aug 2014 22:17:04 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XJVEd-0007Lk-Kv for pgsql-sql@arkaria.postgresql.org; Mon, 18 Aug 2014 22:17:03 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XJVEc-0007LW-Ep for pgsql-sql@postgresql.org; Mon, 18 Aug 2014 22:17:02 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XJVEX-0005pS-AJ for pgsql-sql@postgresql.org; Mon, 18 Aug 2014 22:16:59 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by gateway1.nyi.internal (Postfix) with ESMTP id 14D9623E5C for ; Mon, 18 Aug 2014 18:16:55 -0400 (EDT) Received: from frontend2 ([10.202.2.161]) by compute5.internal (MEProxy); Mon, 18 Aug 2014 18:16:55 -0400 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=aklaver.com; h= message-id:date:from:mime-version:to:cc:subject:references :in-reply-to:content-type:content-transfer-encoding; s=mesmtp; bh=xXhPGgX41JEb3+Kt61MTjzOJPl4=; b=hgNUYqBr91v6uvQH9KlOnj99WcH/ bA/7ZPPfpg5Ev6iUpXYQPbl4N3lrVFJ+utvUeIEYEoVaQOpl+UQhU1jXN6TFT/C2 NEBDYO0YjeCE9ffOgbHR2GYe3T/DDFJvRygBpK+HiJHfgLWZJzaVuss5IV/ciqFN pxH+PD9V43gthXk= DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d= messagingengine.com; h=message-id:date:from:mime-version:to:cc :subject:references:in-reply-to:content-type :content-transfer-encoding; s=smtpout; bh=xXhPGgX41JEb3+Kt61MTjz OJPl4=; b=XzpiBcNE1HgZqgDIfafG6q0Meic8o7rCURav3bIowKMRaru74QVDcW bRGne3T5kVdKHirSdoxMJOXuPPeo4CIVzG3oF+d6UI2XUZ6iroqwKBW5s63iQXXV 84iYnwZN/wf/G8z18Nu8cWFlj7aXi08xirIUzpanpvOlwuYigPmv4= X-Sasl-enc: ZOZg6xXG8w5LzexapltaZHPfw/E//cn0bi/UcbH6kPLR 1408400214 Received: from panda.site (unknown [174.21.203.143]) by mail.messagingengine.com (Postfix) with ESMTPA id 923AB68012E; Mon, 18 Aug 2014 18:16:54 -0400 (EDT) Message-ID: <53F27B55.2090205@aklaver.com> Date: Mon, 18 Aug 2014 15:16:53 -0700 From: Adrian Klaver User-Agent: Mozilla/5.0 (X11; Linux i686; rv:24.0) Gecko/20100101 Thunderbird/24.6.0 MIME-Version: 1.0 To: Marcin Krawczyk CC: "pgsql-sql@postgresql.org" Subject: Re: function call References: <53E0D58E.9040502@aklaver.com> <53E23483.4030906@aklaver.com> <53E91300.1050005@aklaver.com> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org On 08/18/2014 12:57 AM, Marcin Krawczyk wrote: > I wish I was doing that :) that's the first thing I checked. Hmmm. So what happens when you run it in the psql client? Also you say it is only slow when run from your ERP application. Running it from pgAdmin or directly from a C# program is fast. So is there a log for that ERP application that might shed some light on what is going on when the function is run from the application? > > > pozdrowienia > mk > -- Adrian Klaver adrian.klaver@aklaver.com -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql