Re: [GENERAL] Does PostgreSQL ever create indexes on its own?

omas Kellerer writes: >> Doiron, Daniel schrieb am 12.11.2015 um 23:21: >>> I¹m troubleshooting a schema and found this: >>> >>> Indexes: >>> "pk_patient_diagnoses" PRIMARY KEY, btree (id) >>> "index

[GENERAL] Does PostgreSQL ever create indexes on its own?

I’m troubleshooting a schema and found this: Indexes: "pk_patient_diagnoses" PRIMARY KEY, btree (id) "index_4341548" UNIQUE, btree (id) "idx_patient_diagnoses_deleted" btree (deleted) "idx_patient_diagnoses_diagnosis_type_id" btree (diagnosis_type_id) "idx_patient_diagnoses_icd

Re: [GENERAL] replicating many to one

lf Of John R Pierce Sent: Thursday, June 04, 2015 2:46 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] replicating many to one On 6/4/2015 10:07 AM, Doiron, Daniel wrote: > I have a situation where I need to replicate the databases in 4 > clusters on 4 individual servers to a single c

[GENERAL] replicating many to one

I have a situation where I need to replicate the databases in 4 clusters on 4 individual servers to a single cluster on 1 server. So far, the best option looks like pgpool statement-based replication, the major down side being sequences. Does anyone know a better way to achieve this type of repl

Re: [GENERAL] [ADMIN] Active/Active clustering in postgres

Is BDR still in beta? Here’s the postgres wiki with a chart: https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Greg Spiegelberg Sent: Wednesday, November 26, 2014 2:20 P