| From: | Horst Düster <horst(dot)duester(at)sourcepole(dot)ch> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Huge table pg_shdepend |
| Date: | 2019-01-21 13:50:59 |
| Message-ID: | d7963986-0718-6e1a-7355-2c146e350d37@sourcepole.ch |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Am 21.01.19 um 12:19 schrieb Andrew Gierth:
> Note that there's a single pg_shdepend table shared between all
> databases in the cluster; it's not part of any single database but
> rather is a "global" table. So what matters is the total number of
> objects over all databases, not the size of any single db.
OK that declares the size of the table. We have more than 50'000
databases in one cluster.
Regards
Horst
--
Dr. Horst Düster
Managing Director
Sourcepole AG - Linux & Open Source Solutions
Weberstrasse 5, 8004 Zürich, Switzerland
Tel: +41 (0)44 440 77 11
Direkt: +41 (0)44 515 67 70
horst(dot)duester(at)sourcepole(dot)ch http://www.sourcepole.ch
qgiscloud.com - Karten einfach vom Desktop ins Netz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Horst Düster | 2019-01-21 14:09:24 | Calculation of db size |
| Previous Message | Horst Düster | 2019-01-21 11:53:31 | Re: Huge table pg_shdepend |