X-Original-To: pgsql-sql@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 77E8A924D61 for ; Tue, 27 May 2003 10:20:13 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 80767-01 for ; Tue, 27 May 2003 10:20:13 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by developer.postgresql.org (Postfix) with ESMTP id 7DC7F924D5F for ; Tue, 27 May 2003 10:20:12 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h4REKCU6015001; Tue, 27 May 2003 10:20:13 -0400 (EDT) To: "Eric Anderson Vianet SAO" Cc: pgsql-sql@postgresql.org Subject: Re: discover a toast table name In-reply-to: <00e001c32453$2f8f45b0$0701a8c0@netterm> References: <001101c31fb8$ebdb30c0$0701a8c0@netterm> <3ECE195A.7060209@Yahoo.com> <004901c3212e$8919fda0$0701a8c0@netterm> <3ECFE017.7060800@Yahoo.com> <00e001c32453$2f8f45b0$0701a8c0@netterm> Comments: In-reply-to "Eric Anderson Vianet SAO" message dated "Tue, 27 May 2003 10:23:09 -0300" Date: Tue, 27 May 2003 10:20:12 -0400 Message-ID: <15000.1054045212@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/506 X-Sequence-Number: 13671 "Eric Anderson Vianet SAO" writes: > How can I discover which toast table referenced to a phisic table? Look at the base table's pg_class row. reltoastrelid is the OID of the corresponding toast table. So, for example, if I thought "text_tbl" had such a problem: regression=# select relname from pg_class where regression-# oid = (select reltoastrelid from pg_class where relname = 'text_tbl'); relname ----------------- pg_toast_163219 (1 row) regression=# reindex table pg_toast.pg_toast_163219; REINDEX regression=# regards, tom lane