From: Bob Lunney <bob_lunney@yahoo.com>
To: Ross J. Reedstrom <reedstrm@rice.edu>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Really really slow select count(*)
Date: Wed, 16 Feb 2011 11:20:27 -0800 (PST)
Message-ID: <924581.28987.qm@web39707.mail.mud.yahoo.com> (raw)
In-Reply-To: <20110216162832.GA17015@rice.edu>
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 <reedstrm@rice.edu> wrote:
> From: Ross J. Reedstrom <reedstrm@rice.edu>
> Subject: Re: [PERFORM] Really really slow select count(*)
<<big snip>>
>
> 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."
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: bob_lunney@yahoo.com, reedstrm@rice.edu
Subject: Re: Really really slow select count(*)
In-Reply-To: <924581.28987.qm@web39707.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox