Home > mailing lists

Schema Consolidation in PostgreSQL - Mailing list pgsql-admin

From	Wei Shan
Subject	Schema Consolidation in PostgreSQL
Date	May 8, 2015 09:38:24
Msg-id	CAFe9ZTqb9oiQ0TRe5Qrgg=Ptgc0cx5zn=CCFxqEFfLeSeSRTqQ@mail.gmail.com Whole thread Raw
Responses	Re: Schema Consolidation in PostgreSQL Re: Schema Consolidation in PostgreSQL
List	pgsql-admin

Hi all!

I have a database with multiple schemas consolidated within a postgres database.

I have 2 issues when working with this setup.

1. How can I ensure that there's no resource contention between the schemas? Is there any resource manager.

2. Can I get schema-level performance statistics? If I see that this schema is overloaded, I may move it to another server.

Thanks!

Regards,
Ang Wei Shan

From: Zoltan Szecsei
Date: 07 May 2015, 20:33:19
Subject: Re: connect postgresql to a different cluster

From: Albe Laurenz
Date: 08 May 2015, 10:50:48
Subject: Re: Schema Consolidation in PostgreSQL