From: Benjamin Krajmalnik <kraj@illumen.com>
To: pgsql-admin@postgresql.org
Subject: Identifying object from file on disk
Date: Wed, 12 Jul 2006 23:27:02 -0600
Message-ID: <BF337097BDD9D849A2F4B818DDB2798702943A@stash.stackdump.local> (raw)
I have a very strange situation where all of a sudden my database growth
has increased dramatically.
I made some schema changes, bit these were made to some tables which do
not have the massive insertion rate (a few fields were changed from
varchar to inet data types.
The tables which have the massive insertion rates of records were not
changed.
The tables with the high insertion rate are partitioned tables.
I would like to identify the objects which all of a sudden are frowing
at the high growth rate by using the filename (which I assune is the
OID). I have looked at the pg_catalog schema to see if I could see an
obvious way to do this, but to no avail. Furthermore, I hate to keep
bothering the ng with these types of questions - is there a reference
which lists the functions/views available in pg_catalog which can be
used for this type of check?
TA,
Benjamin
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: kraj@illumen.com
Subject: Re: Identifying object from file on disk
In-Reply-To: <BF337097BDD9D849A2F4B818DDB2798702943A@stash.stackdump.local>
References: <BF337097BDD9D849A2F4B818DDB2798702943A@stash.stackdump.local>
* 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