Re: [PERFORM] DRBD and Postgres: how to improve the perfomance?

2007-09-08 Thread Joshua D. Drake
-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

Re: [PERFORM] DRBD and Postgres: how to improve the perfomance?

2007-09-08 Thread Joshua D. Drake
-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

Re: [PERFORM] DRBD and Postgres: how to improve the perfomance?

2007-09-08 Thread Bernd Helmle
--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

Re: [PERFORM] DRBD and Postgres: how to improve the perfomance?

2007-09-08 Thread Gregory Stark
"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

Re: [PERFORM] DRBD and Postgres: how to improve the perfomance?

2007-09-08 Thread Stefan Kaltenbrunner
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

Re: [PERFORM] DRBD and Postgres: how to improve the perfomance?

2007-09-08 Thread Joshua D. Drake
-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

Re: [PERFORM] DRBD and Postgres: how to improve the perfomance?

2007-09-08 Thread Joshua D. Drake
-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

Re: [PERFORM] DRBD and Postgres: how to improve the perfomance?

2007-09-08 Thread Gregory Stark
"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

Re: [PERFORM] DRBD and Postgres: how to improve the perfomance?

2007-09-08 Thread Tom Lane
"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

Re: [PERFORM] DRBD and Postgres: how to improve the perfomance?

2007-09-08 Thread Stefan Kaltenbrunner
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

Re: [PERFORM] DRBD and Postgres: how to improve the perfomance?

2007-09-08 Thread Joshua D. Drake
-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

Re: [PERFORM] DRBD and Postgres: how to improve the perfomance?

2007-09-08 Thread Gregory Stark
"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

Re: [PERFORM] optimize query with a maximum(date) extraction

2007-09-08 Thread Dimitri
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