Thread: PG clustering

PG clustering

From
CSN
Date:
Just wondering - is there something similar to this
(clustering) for PostgreSQL? If so, how does it
compare?

http://www.mysql.com/press/release_2003_30.html



__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

Re: PG clustering

From
Richard Huxton
Date:
On Wednesday 15 October 2003 04:36, CSN wrote:
> Just wondering - is there something similar to this
> (clustering) for PostgreSQL? If so, how does it
> compare?
>
> http://www.mysql.com/press/release_2003_30.html

What does this do and how?


--
  Richard Huxton
  Archonet Ltd

Re: PG clustering

From
Tino Wildenhain
Date:
Hi,

CSN wrote:
> Just wondering - is there something similar to this
> (clustering) for PostgreSQL? If so, how does it
> compare?
>
> http://www.mysql.com/press/release_2003_30.html
>
Marketing... they're lying the hell out of anything.
"mission critical business apps" *muhahaha*
"640K are enough for everybody" "nobody needs transactions" ;)

afaik, with clustering you can in theory improve read
spead and with luck reliability (according to reads)
but at the cost of write speed and write reliablility.

Mental note to postgres developers:
   - when WAL files could be read over network as well,
     might clustering in the above sense maybe implemented
     by replicating WAL files and until replicated
     accessing them over the net?
(Just wild spinning of thougts, sorry)

Regards
Tino