-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Joshua D. Drake wrote:
> Stefan Kaltenbrunner wrote:
>> Joshua D. Drake wrote:
>>> Stefan Kaltenbrunner wrote:
>
how is that making it different in practise ? - if both are on the same
UPS they are affectively on the same power bus ...
>>> W
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stefan Kaltenbrunner wrote:
> Joshua D. Drake wrote:
>> Stefan Kaltenbrunner wrote:
>>> how is that making it different in practise ? - if both are on the same
>>> UPS they are affectively on the same power bus ...
>> Well I was thinking the bus that
--On Samstag, September 08, 2007 12:39:37 -0400 Tom Lane
<[EMAIL PROTECTED]> wrote:
However, it seems like the point here is not so much "can you recover
your data" as what a commit means. Do you want a commit reported to the
client to mean the data is safely down to disk in both places, or on
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> It isn't my faith in a UPS. It is my real world knowledge.
>
> Further I will exert what I already replied to Stefan:
>
> city power->line conditioning generator->panel->plug->UPS->server
>
> You would have to have lightning handed by God to your ser
Joshua D. Drake wrote:
> Stefan Kaltenbrunner wrote:
>> Joshua D. Drake wrote:
>>> Gregory Stark wrote:
"Simon Riggs" <[EMAIL PROTECTED]> writes:
> You're right, but the distinction is a small one. What are the chances
> of losing two independent servers within a few milliseconds of ea
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Gregory Stark wrote:
> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
>
>> That chance is minuscule or at least should be. Of course we are
>> assuming some level of conditioned power that is independent of the
>> power bus, e.g; a UPS.
>
> I find you
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stefan Kaltenbrunner wrote:
> Joshua D. Drake wrote:
>> Gregory Stark wrote:
>>> "Simon Riggs" <[EMAIL PROTECTED]> writes:
You're right, but the distinction is a small one. What are the chances
of losing two independent servers within a few m
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> That chance is minuscule or at least should be. Of course we are
> assuming some level of conditioned power that is independent of the
> power bus, e.g; a UPS.
I find your faith in UPSes charmingly quaint.
--
Gregory Stark
EnterpriseDB
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> Gregory Stark wrote:
>> "Simon Riggs" <[EMAIL PROTECTED]> writes:
>>> You're right, but the distinction is a small one. What are the chances
>>> of losing two independent servers within a few milliseconds of each
>>> other?
>>
>> If they're on the s
Joshua D. Drake wrote:
> Gregory Stark wrote:
>> "Simon Riggs" <[EMAIL PROTECTED]> writes:
>
>>> You're right, but the distinction is a small one. What are the chances
>>> of losing two independent servers within a few milliseconds of each
>>> other?
>> If they're on the same power bus?
>
> That
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Gregory Stark wrote:
> "Simon Riggs" <[EMAIL PROTECTED]> writes:
>
>> You're right, but the distinction is a small one. What are the chances
>> of losing two independent servers within a few milliseconds of each
>> other?
>
> If they're on the same
"Simon Riggs" <[EMAIL PROTECTED]> writes:
> You're right, but the distinction is a small one. What are the chances
> of losing two independent servers within a few milliseconds of each
> other?
If they're on the same power bus?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb
BTW, will it improve something if you change your index to "my_table(
id, the_date )"?
Rgds,
-Dimitri
On 9/5/07, JS Ubei <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I need to improve a query like :
>
> SELECT id, min(the_date), max(the_date) FROM my_table GROUP BY id;
>
> Stupidly, I create a B-tree
13 matches
Mail list logo