X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 064DD9FB2D5 for ; Thu, 13 Jul 2006 02:27:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 22044-02-2 for ; Thu, 13 Jul 2006 02:27:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from stash.illumen.com (unknown [64.207.29.137]) by postgresql.org (Postfix) with ESMTP id 75C6B9FB31D for ; Thu, 13 Jul 2006 02:27:24 -0300 (ADT) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Subject: Identifying object from file on disk X-MimeOLE: Produced By Microsoft Exchange V6.5 Date: Wed, 12 Jul 2006 23:27:02 -0600 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Identifying object from file on disk thread-index: AcamM5SgrJYucHjoQAabjq3G/X6CVgACBItw From: "Benjamin Krajmalnik" To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/82 X-Sequence-Number: 22328 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