>>>>> "Horst" == Horst Düster <horst.duester@xxxxxxxxxxxxx> 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)
