relation between records in "main" and "toast" tables

From: "Igor Neyman" <ineyman(at)perceptron(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: relation between records in "main" and "toast" tables
Date: 2010-01-25 19:50:01
Message-ID: F4C27E77F7A33E4CA98C19A9DC6722A20573AF6E@EXCHANGE.corp.perceptron.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

Let's say TableA has "toastable" column, the contents of this column is
stored in let's say pg_toast_1234.

Is there a query to find which records (chunk_id, chunk_seq) in
pg_toast_1234 store data for specific record in TableA (i.e. with PK
column value eq. '567')?

Igor Neyman

Browse pgsql-admin by date

  From Date Subject
Next Message Dimitri Fontaine 2010-01-26 09:18:11 Re: how to speed ilike
Previous Message Michael Monnerie 2010-01-25 16:37:05 Re: max_fsm_pages question