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

This is a multi-part message in MIME format.

------_=_NextPart_001_01CA9DF7.95334098
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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

------_=_NextPart_001_01CA9DF7.95334098
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.6000.16981" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D537014519-25012010><FONT face=3DArial
size=3D2>Hello,</FONT></SPAN></DIV>
<DIV><SPAN class=3D537014519-25012010><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D537014519-25012010><FONT face=3DArial size=3D2>Let's =
say TableA has
"toastable" column, the contents of this column is stored in let's
say pg_toast_1234.</FONT></SPAN></DIV>
<DIV><SPAN class=3D537014519-25012010><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D537014519-25012010><FONT face=3DArial size=3D2>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')?</FONT></SPAN></DIV>
<DIV><SPAN class=3D537014519-25012010><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D537014519-25012010><FONT face=3DArial size=3D2>Igor
Neyman</FONT></SPAN></DIV></BODY></HTML>

------_=_NextPart_001_01CA9DF7.95334098--
Igor Neyman [ Mo, 25 Januar 2010 20:50 ] [ ID #2029781 ]
Datenbanken » gmane.comp.db.postgresql.admin » relation between records in "main" and "toast" tables

Vorheriges Thema: how to speed ilike
Nächstes Thema: max_fsm_pages question