From: Andrew Gierth <andrew@tao11.riddles.org.uk>
To: Horst =?utf-8?Q?D=C3=BCster?= <horst.duester@sourcepole.ch>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Huge table pg_shdepend
In-Reply-To: <7ecdbaa3-07a6-1ec1-d991-06440c05b4cb@sourcepole.ch> ("Horst
	\=\?utf-8\?Q\?D\=C3\=BCster\=22's\?\= message of "Mon,
 21 Jan 2019 11:18:37 +0100")
Message-ID: <87o98a468n.fsf@news-spur.riddles.org.uk>
References: <7ecdbaa3-07a6-1ec1-d991-06440c05b4cb@sourcepole.ch>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (berkeley-unix)
Date: Mon, 21 Jan 2019 11:19:58 +0000
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Precedence: bulk

>>>>> "Horst" =3D=3D Horst D=C3=BCster <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.

--=20
Andrew (irc:RhodiumToad)