Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T00UA-0002v2-9n for pgsql-general@postgresql.org; Sat, 11 Aug 2012 01:27:26 +0000 Received: from hogranch.com ([75.101.82.47]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T00U8-0000Zk-Ia for pgsql-general@postgresql.org; Sat, 11 Aug 2012 01:27:26 +0000 Received: from [192.168.0.2] (porker [192.168.0.2]) by hogranch.com (8.11.6/8.11.6) with ESMTP id q7B1RG927318 for ; Fri, 10 Aug 2012 18:27:16 -0700 Message-ID: <5025B4EF.4080303@hogranch.com> Date: Fri, 10 Aug 2012 18:27:11 -0700 From: John R Pierce User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:14.0) Gecko/20120713 Thunderbird/14.0 MIME-Version: 1.0 To: PostgreSQL Subject: Re: partitioning References: <5025AD10.5030004@hogranch.com> <14FC3FAC-5DE7-44A0-BDCB-4916F196B6FD@codepuppy.com> In-Reply-To: <14FC3FAC-5DE7-44A0-BDCB-4916F196B6FD@codepuppy.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-HawgScanner-Information: Please contact the ISP for more information X-HawgScanner: Found to be clean X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201208/217 X-Sequence-Number: 189394 On 08/10/12 6:00 PM, Jeff Potter wrote: > Is it possible that you have any "idle in transaction" connections holding those tables open? See what you get when you show locks. its very possible. the developer thought he'd fixed all those and was surprised they were recurring. they are coming from JDBC by default starting a transaction on a simple SELECT. we don't 'commit' after selects as this code was written for Oracle, where plain selects dont have side effects like this. this is only a problem in Postgres. the intent is to use connections with 'autocommit on' for pure read threads.... however, this is a very large and complex code base, and site specific code is added by field engineering, so sometimes stuff slips in. -- john r pierce N 37, W 122 santa cruz ca mid-left coast