pg_shdepend big

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_shdepend big
Date: 2007-08-03 16:09:32
Message-ID: f8vk0h$1b6h$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Simonaitis 2007-08-03 17:15:04 Table queue (locking)
Previous Message Joshua D. Drake 2007-08-03 16:04:47 Re: pgpool2 vs sequoia