Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 51F371337B9E for ; Wed, 16 Feb 2011 15:20:40 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 23827-03 for ; Wed, 16 Feb 2011 19:20:32 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from web39707.mail.mud.yahoo.com (web39707.mail.mud.yahoo.com [209.191.106.53]) by mail.postgresql.org (Postfix) with SMTP id 68C991337BBC for ; Wed, 16 Feb 2011 15:20:31 -0400 (AST) Received: (qmail 38448 invoked by uid 60001); 16 Feb 2011 19:20:28 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1297884027; bh=mAPCnNdbi092bqcwha+eBL7jjpWeA7N0d4v3RjvhI9M=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=dA+TrN8T2AgphxSxqGbWeKFAlRGCzXpkGGGHWTUdTyA2sa3eZRjFT+O4oEcv8S+BOAVjjKwNdXv2oznfJAwK58+FckE+gT2lcNS0hlqPvvML3abptmBn22oYKWV5D+vy/K1tK3mWq6N3j6g75h8F7+CvH6A2KUHdu3xbCjAHHzQ= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=5AjSAjbpgCuT6OK/boLrt7Oe8JTuU5OAXHr/vENB02Xh4jYhes0G4P1z9Yq4Px9UZRi4dLjrbi9PmpqS5tb5WtUdizTdtchL7Mc6V4USmXDouveARXHKptF/jAZyPK51Cw7Li7uhwIs0CK6Knh+Y3hv6JRI/QJFB5S2Yo9nwV84=; Message-ID: <924581.28987.qm@web39707.mail.mud.yahoo.com> X-YMail-OSG: 82xH7mQVM1mD6OmYEy_V7OVNHUIrifmjFRB9wjHQhzR_Mis FXeBg9B4Bvt_E0288b2yO7GNph1OQ5WzOpYhW3ib3wWY3lqcIzX6NoZd8Mkz bEL5DEtlcMBhmZR2xlfmwBzC.D5uw.FYFC73mFDMA_Jn_Qo1S169u58R3LvF hkFqnEO1dwsDrJdbPTZqH.mxTlnGY69y7lfej7O.XNxbscTlgQ_0w9akXvzi ZdRUvZSwmxd1EYhFEwOeSjyhk3XL4Q9LWSPoQRjoc9O0HTkxzyMNuBQVVsYZ NQAavXryZQqQiJed2B1zvJkXU7ATJh5F4RiJstShNIuTrbbkU Received: from [64.126.29.122] by web39707.mail.mud.yahoo.com via HTTP; Wed, 16 Feb 2011 11:20:27 PST X-Mailer: YahooMailClassic/11.4.20 YahooMailWebService/0.8.108.291010 Date: Wed, 16 Feb 2011 11:20:27 -0800 (PST) From: Bob Lunney Subject: Re: Really really slow select count(*) To: "Ross J. Reedstrom" Cc: "pgsql-performance@postgresql.org" In-Reply-To: <20110216162832.GA17015@rice.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.908 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201102/415 X-Sequence-Number: 42553 Ross, Way off topic now, but from my time programming electrical meters I can tell you pulling the meter from its socket is potentially an extremely dangerous thing to do. If there is a load across the meter's poles the spark that results on disconnect could kill the puller instantly. (You don't want to know what happens if the person isn't killed.) I don't know what property your admin type is trying to protect, but I'm inclined to let it burn and live to work through the insurance collection process. Oh, and +1 for timed escalation of a shutdown. Bob Lunney --- On Wed, 2/16/11, Ross J. Reedstrom wrote: > From: Ross J. Reedstrom > Subject: Re: [PERFORM] Really really slow select count(*) <> > > Following you off topic, I know of one admin type who has > stated "I don't > care what sort of fine the power company wants to give me, > if my > property's on fire, I'm going to pull the meter, in order > to hand it to > the first responder, rather than have them sit there > waiting for the > power tech to arrive while my house burns."