Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 2C57C632C86 for ; Thu, 15 Apr 2010 17:14:34 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 36584-10 for ; Thu, 15 Apr 2010 20:14:23 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 962EE632C47 for ; Thu, 15 Apr 2010 17:14:23 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o3FKE1Hg016089; Thu, 15 Apr 2010 16:14:01 -0400 (EDT) To: Alvaro Herrera cc: Josh Berkus , pgsql-performance@postgresql.org Subject: Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine In-reply-to: <20100415200056.GJ7259@alvh.no-ip.org> References: <4BC76C9F.1020200@agliodbs.com> <20100415200056.GJ7259@alvh.no-ip.org> Comments: In-reply-to Alvaro Herrera message dated "Thu, 15 Apr 2010 16:00:56 -0400" Date: Thu, 15 Apr 2010 16:14:01 -0400 Message-ID: <16088.1271362441@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.51 tagged_above=-10 required=5 tests=BAYES_05=-0.5, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201004/190 X-Sequence-Number: 38440 Alvaro Herrera writes: > We don't call pollsys anywhere. Something in Solaris must be doing it > under the hood. pg_usleep calls select(), and some googling indicates that select() is implemented as pollsys() on recent Solaris versions. So Josh's assumption that those are delay calls seems plausible. But it shouldn't be sleeping after each page with normal cost_delay parameters, should it? regards, tom lane