Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Uyj4m-0001E1-IZ for pgsql-admin@arkaria.postgresql.org; Mon, 15 Jul 2013 13:44:28 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Uyj4m-0004UW-2R for pgsql-admin@arkaria.postgresql.org; Mon, 15 Jul 2013 13:44:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Uyj4l-0004UQ-1X for pgsql-admin@postgresql.org; Mon, 15 Jul 2013 13:44:27 +0000 Received: from nm10-vm1.bullet.mail.ird.yahoo.com ([77.238.189.93]) by magus.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Uyj4h-0002jw-Bd for pgsql-admin@postgresql.org; Mon, 15 Jul 2013 13:44:26 +0000 Received: from [77.238.189.49] by nm10.bullet.mail.ird.yahoo.com with NNFMP; 15 Jul 2013 13:44:21 -0000 Received: from [46.228.39.84] by tm2.bullet.mail.ird.yahoo.com with NNFMP; 15 Jul 2013 13:44:21 -0000 Received: from [127.0.0.1] by smtp121.mail.ir2.yahoo.com with NNFMP; 15 Jul 2013 13:44:21 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.es; s=s1024; t=1373895861; bh=OrjP76m9l9ao7gFfns9jEW8hEJTI27RkdJcet9gBaCQ=; h=X-Yahoo-Newman-Id:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:X-Rocket-Received:Date:From:To:Subject:Message-Id:In-Reply-To:References:X-Mailer:Disposition-Notification-To:Mime-Version:Content-Type:Content-Transfer-Encoding; b=TZbSSx4uICwORsBhMArOGSPKLktpGi8KatehVFWJyauqS3yZwbPiKWjLLVmVTvH8eZz7NbQIAga3ivBUAGvWTkNrr9ARLUDDLPuLi+ikW+/1ZKwyj7XVn/foWoyElB2+/pbU1ZA7rN72i2y7OUHBHQFkvEkcYiryk4SbpB8hKio= X-Yahoo-Newman-Id: 435793.73178.bm@smtp121.mail.ir2.yahoo.com X-Yahoo-Newman-Property: ymail-3 X-YMail-OSG: nZ30UtwVM1lXMQkJcoG3vhDyMQWczlQ_Y4_Vy2Ri06NPPOT 98IYtRcB5x2R4KhX1hZHdL5XaCKYBYAivbtEvLI6kJ7Wt8ZHq_Qv7J1RuvSb HsHvW3ET8iY3MsFHeALBo2rv5ynPRvlQ4B0PB1.GHRkdz11lAdAEppoBLfip gf1zZZYvgYXvmnNQMpJwjiHITXHIfSZ9K6Q61ShUfIOzd7AzbYKEUjXsjQtX vD69rB2sMP77zXKJDqK9SgJw_9hmuHiKNAhCc8ScWrnJcm8MJoS.plRhRnrO dV9aJzLRAD5QUVH7inDKj8aLX4Lqqs8ARshUzEBAHVU_bAgkcN4ftfwJ.dii dobdlA6y07neNSKpoQxTzeh9Gj2Xa2A.EdrE1LH6vDwrB4OPeBe_QTG1A2iY tHXuF709BkQVWOnZxXVks8cwZYOv7Lo6Qvoj2b4UENol.rBa7bQgxcFa8Sco J0uWfF_tpj0C_mszj9lL0ykyhHdR4 X-Yahoo-SMTP: mX392iiswBAeJNdO_s.EW62LZDJR X-Rocket-Received: from camibar.emorras.eu (emorrasg@89.7.216.154 with ) by smtp121.mail.ir2.yahoo.com with SMTP; 15 Jul 2013 13:44:21 +0000 UTC Date: Mon, 15 Jul 2013 15:44:28 +0200 From: Eduardo Morras To: pgsql-admin@postgresql.org Subject: Re: 9.2.2 - semop hanging Message-Id: <20130715154428.7867d7d74e4cbca04d8b7e4a@yahoo.es> In-Reply-To: References: X-Mailer: Sylpheed 3.3.0 (GTK+ 2.24.19; amd64-portbld-freebsd9.1) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -0.1 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On Mon, 15 Jul 2013 10:16:19 -0300 Rafael Domiciano wrote: I'm not a Linux expert, I'm a BSD man, but a) do you have an interrupt storm? b) what does postgres do before the hang? c) do you have anyother software running? Including contrib modules. It may be a dns lookup timeout (watch port 53 tcp/udp) d) what filesystem? Needs filesystem some kind of "maintenance window"? I mean flush dirty caches, metadata, wake up barriers... --- --- Eduardo Morras -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin