Skip site navigation (1) Skip section navigation (2)

Re: Addition to TOAST documentation in 8.4 comprehensive manual

From: Aleksey Tsalolikhin <atsaloli(dot)tech(at)gmail(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: Addition to TOAST documentation in 8.4 comprehensive manual
Date: 2011-01-08 15:58:01
Message-ID: AANLkTi=92odVUqT0zPp2q=y_vrxGMJ75nOmRxEnvCk6k@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-docs
On Sat, Jan 8, 2011 at 3:16 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Wed, Dec 22, 2010 at 9:05 PM, Aleksey Tsalolikhin
> <atsaloli(dot)tech(at)gmail(dot)com> wrote:
>> I'd like to add the following to my proposed documentation tidbit, please:
>>

>
> I think this might be a good thing to mention somewhere, but can you
> make a more specific proposal about where you think it should be put,
> maybe in the form of a patch?

Thank you very much, Robert.  I propose it be appended to the 8.4
comprehensive manual, Chapter 53.2 TOAST.  (And the 9 manual, if it's
true for 9.  I haven't touched 9 yet but I'm assuming this hasn't
changed?)

Here is the patch for 9.0.2 DocBook SGML:

*** storage.sgml.orig   2011-01-08 10:38:23.000000000 -0500
--- storage.sgml        2011-01-08 10:48:53.000000000 -0500
***************
*** 404,409 ****
--- 404,421 ----
  comparison table, in which all the HTML pages were cut down to 7 kB to fit.
  </para>

+ <para>
+ To find the parent table given a <acronym>TOAST<acronym> table which has a
+ name like pg_toast_12513885, run:
+ </para>
+
+ <para>
+ <programlisting>
+ select oid::regclass from pg_class where
+ reltoastrelid='pg_toast_12513885'::regclass;
+ </programlisting>
+ </para>
+
  </sect1>

  <sect1 id="storage-fsm">


And here is the patch for the 8.4.6 documentation:

*** storage.sgml.orig   2011-01-08 10:56:04.000000000 -0500
--- storage.sgml        2011-01-08 10:56:06.000000000 -0500
***************
*** 374,379 ****
--- 374,393 ----
  comparison table, in which all the HTML pages were cut down to 7 kB to fit.
  </para>

+
+ <para>
+ To find the parent table given a <acronym>TOAST<acronym> table which has a
+ name like pg_toast_12513885, run:
+ </para>
+
+ <para>
+ <programlisting>
+ select oid::regclass from pg_class where
+ reltoastrelid='pg_toast_12513885'::regclass;
+ </programlisting>
+ </para>
+
+
  </sect1>

  <sect1 id="storage-fsm">


Yours truly,
Aleksey

In response to

Responses

pgsql-docs by date

Next:From: Josh KupershmidtDate: 2011-01-11 04:11:42
Subject: typofix for prepare transaction page
Previous:From: Robert HaasDate: 2011-01-08 11:16:33
Subject: Re: Addition to TOAST documentation in 8.4 comprehensive manual

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group