Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id B1F36633103 for ; Tue, 17 Feb 2009 17:03:03 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 31006-05 for ; Tue, 17 Feb 2009 17:02:58 -0400 (AST) X-Greylist: delayed 00:07:53.356206 by SQLgrey-1.7.6 Received: from mail.pommesbude.org (mail.pommesbude.org [88.198.164.122]) by mail.postgresql.org (Postfix) with ESMTP id AF5666330F0 for ; Tue, 17 Feb 2009 17:02:56 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by mail.pommesbude.org (Postfix) with ESMTP id EA213D5C9E5 for ; Tue, 17 Feb 2009 21:54:59 +0100 (CET) X-Virus-Scanned: amavisd-new 2.6.1 (20080629) at pommesbude.org Received: from mail.pommesbude.org ([88.198.164.122]) by localhost (mail.pommesbude.org [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id SCDMjTn3xbYV for ; Tue, 17 Feb 2009 21:54:59 +0100 (CET) Received: from MacBook.local (xdsl-213-196-243-56.netcologne.de [213.196.243.56]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.pommesbude.org (Postfix) with ESMTPSA id 5E37BD5BBD3 for ; Tue, 17 Feb 2009 21:54:59 +0100 (CET) Message-ID: <499B2423.3000809@d0pefish.de> Date: Tue, 17 Feb 2009 21:54:59 +0100 From: Peter Hinse User-Agent: Thunderbird 2.0.0.19 (Macintosh/20081209) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: lseek Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200902/130 X-Sequence-Number: 31351 Hi all, what might possibly be wrong with a database/statement what so ever, if a strace to a postgres process shows this over several ours without terminating? lseek(3, 0, SEEK_END) = 0 lseek(5, 0, SEEK_END) = 8192 lseek(6, 0, SEEK_END) = 0 lseek(9, 0, SEEK_END) = 0 lseek(10, 0, SEEK_END) = 0 lseek(11, 0, SEEK_END) = 0 lseek(13, 0, SEEK_END) = 0 lseek(14, 0, SEEK_END) = 0 lseek(15, 0, SEEK_END) = 0 lseek(16, 0, SEEK_END) = 0 lseek(17, 0, SEEK_END) = 0 lseek(18, 0, SEEK_END) = 0 lseek(19, 0, SEEK_END) = 0 lseek(20, 0, SEEK_END) = 0 lseek(21, 0, SEEK_END) = 11214848 lseek(22, 0, SEEK_END) = 0 lseek(23, 0, SEEK_END) = 0 lseek(24, 0, SEEK_END) = 0 lseek(25, 0, SEEK_END) = 0 lseek(26, 0, SEEK_END) = 0 lseek(27, 0, SEEK_END) = 0 lseek(28, 0, SEEK_END) = 0 lseek(29, 0, SEEK_END) = 0 lseek(30, 0, SEEK_END) = 0 lseek(31, 0, SEEK_END) = 0 lseek(32, 0, SEEK_END) = 0 lseek(3, 0, SEEK_END) = 0 lseek(5, 0, SEEK_END) = 8192 lseek(6, 0, SEEK_END) = 0 lseek(9, 0, SEEK_END) = 0 lseek(10, 0, SEEK_END) = 0 lseek(11, 0, SEEK_END) = 0 lseek(13, 0, SEEK_END) = 0 lseek(14, 0, SEEK_END) = 0 lseek(15, 0, SEEK_END) = 0 lseek(16, 0, SEEK_END) = 0 lseek(17, 0, SEEK_END) = 0 lseek(18, 0, SEEK_END) = 0 lseek(19, 0, SEEK_END) = 0 lseek(20, 0, SEEK_END) = 0 lseek(21, 0, SEEK_END) = 11214848 More info: the statement is an INSERT with some huge subselects, running every night on a PGSQL 8.3.6 on CentOS 4.7 x86_64. In 97% of all occasions, the job terminates in about 1-2 minutes - however, sometimes it just hangs. If terminated with kill and restarted, it always terminates. Clueless, Peter