Schema Consolidation in PostgreSQL

From: Wei Shan <weishan(dot)ang(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Schema Consolidation in PostgreSQL
Date: 2015-05-08 06:38:20
Message-ID: CAFe9ZTqb9oiQ0TRe5Qrgg=Ptgc0cx5zn=CCFxqEFfLeSeSRTqQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Albe Laurenz 2015-05-08 07:50:41 Re: Schema Consolidation in PostgreSQL
Previous Message phuongnh2 2015-05-08 04:41:46 Re: Issue import (COPY) data by between miss lines