From: Andrew Gierth <andrew@tao11.riddles.org.uk>
To: Horst Düster <horst.duester@sourcepole.ch>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Huge table pg_shdepend
Date: Mon, 21 Jan 2019 11:19:58 +0000
Message-ID: <87o98a468n.fsf@news-spur.riddles.org.uk> (raw)
In-Reply-To: <7ecdbaa3-07a6-1ec1-d991-06440c05b4cb@sourcepole.ch>
References: <7ecdbaa3-07a6-1ec1-d991-06440c05b4cb@sourcepole.ch>
>>>>> "Horst" == Horst Düster <horst.duester@sourcepole.ch> writes:
Horst> Hi
Horst> I'm struggling with a huge table pg_shdepend. My database has a
Horst> size of 640MB exclude the size of the system tables. But the
Horst> real size of the db is more than 2GB. The reason is a huge table
Horst> pg_shdepend with more than 32000000 records.
pg_shdepend has a row for every object and every ACL entry that records
which role (other than the initial db superuser) owns the object or is
referenced from the ACL entry.
Do you have an unusually large number of tables (or other database
objects)?
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.
--
Andrew (irc:RhodiumToad)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: andrew@tao11.riddles.org.uk, horst.duester@sourcepole.ch, pgsql-admin@lists.postgresql.org
Subject: Re: Huge table pg_shdepend
In-Reply-To: <87o98a468n.fsf@news-spur.riddles.org.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox