Re: [PERFORM] postgres clustering interactions with pg_dump

2012-07-23 Thread Robert Haas
On Mon, Jun 11, 2012 at 9:55 AM, Fitch, Britt wrote: > Hi, I have a table that I am clustering on an index. > > I am then dumping that table via pg_dump –Fc and loading it into another > database via pg_restore. > > It is unclear to me though if the clustering I did in the original database > is p

[PERFORM] postgres clustering interactions with pg_dump

2012-06-11 Thread Fitch, Britt
Hi, I have a table that I am clustering on an index. I am then dumping that table via pg_dump -Fc and loading it into another database via pg_restore. It is unclear to me though if the clustering I did in the original database is preserved during the dump & restore or if I would still need to per

Re: [GENERAL] [PERFORM] Postgres Clustering

2009-07-14 Thread Tim Uckun
2009/5/28 Eddy Ernesto Baños Fernández : > Try Cybercluster I looked into that. There is one piece of documentation that is less than ten pages long. There is no users group, no listserve, no community that I can discern. Do you have experience with it and if so could you please share. Thank

Re: [PERFORM] Postgres Clustering

2009-05-27 Thread Alan McKay
> Depending on your exact needs, which the terminology you're using only allow > to guess about, you might enjoy this reading: >  http://wiki.postgresql.org/wiki/Image:Moskva_DB_Tools.v3.pdf Thanks. To be honest I don't even know myself what my needs are yet. I've only been on the job here for a

Re: [PERFORM] Postgres Clustering

2009-05-27 Thread Dimitri Fontaine
Hi, Le 27 mai 09 à 19:57, Alan McKay a écrit : I have done some googling and found a few things on the matter. But am looking for some suggestions from the experts out there. Got any good pointers for reading material to help me get up to speed on PostgreSQL clustering? What options are avai

Re: [PERFORM] Postgres Clustering

2009-05-27 Thread Eddy Ernesto Baños Fernández
] Postgres Clustering Hey folks, I have done some googling and found a few things on the matter. But am looking for some suggestions from the experts out there. Got any good pointers for reading material to help me get up to speed on PostgreSQL clustering? What options are available? What are

Re: [PERFORM] Postgres Clustering

2009-05-27 Thread Daniel van Ham Colchete
Alan, here I'm implementing something similar to the Chord protocol [1] on the application level to partition my data across 6 PostgreSQL servers with N+1 replication. Two up sides on this approch: 1 - When one server is down the load is spread between all the other ones, instead of going only to

Re: [PERFORM] Postgres Clustering

2009-05-27 Thread Scott Mead
On Wed, May 27, 2009 at 1:57 PM, Alan McKay wrote: > Hey folks, > > I have done some googling and found a few things on the matter. But > am looking for some suggestions from the experts out there. > > Got any good pointers for reading material to help me get up to speed > on PostgreSQL clusteri

Re: [PERFORM] Postgres Clustering

2009-05-27 Thread Thomas Kellerer
Alan McKay wrote on 27.05.2009 19:57: > What options are available? I guess a good starting point is the Postgres Wiki: http://wiki.postgresql.org/wiki/Replication%2C_Clustering%2C_and_Connection_Pooling -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make chan

[PERFORM] Postgres Clustering

2009-05-27 Thread Alan McKay
Hey folks, I have done some googling and found a few things on the matter. But am looking for some suggestions from the experts out there. Got any good pointers for reading material to help me get up to speed on PostgreSQL clustering? What options are available? What are the issues? Terminol