Postgres Pro
Downloads
Home   >   mailing lists

relation between records in "main" and "toast" tables - Mailing list pgsql-admin

From Igor Neyman
Subject relation between records in "main" and "toast" tables
Date
Msg-id F4C27E77F7A33E4CA98C19A9DC6722A20573AF6E@EXCHANGE.corp.perceptron.com
Whole thread Raw
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Michael Monnerie
Date:
Subject: Re: max_fsm_pages question
Next
From: Dimitri Fontaine
Date:
Subject: Re: how to speed ilike