pg_shdepend big

Started by Andrusover 18 years ago2 messagesgeneral
Jump to latest
#1Andrus
kobruleht2@hot.ee

Cluster contains only single user database. Database size is 355 MB
All database objects are owned by single role.

I selected bigger tables from database and found that pg_shdepend is big:

First number is table size, second number is table size with index files.

pg_shdepend 9352 kB 18 MB
pg_shdepend_depender_index 7344 kB 7344 kB
pg_shdepend_reference_index 1312 kB 1312 kB
pg_depend_depender_index 1040 kB 1040 kB

Is it normal that pg_shdepend is so big ?

Andrus.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Andrus (#1)
Re: pg_shdepend big

"Andrus" <kobruleht2@hot.ee> writes:

Is it normal that pg_shdepend is so big ?

This was just discussed:
http://archives.postgresql.org/pgsql-general/2007-08/msg00121.php

regards, tom lane