Re: Addition to TOAST documentation in 8.4 comprehensive manual

Hi, how about my more specific proposal, in the form of a patch, please? (it is
below in my quoted email of 8 Jan 2011.)

It's my first time offering a patch for PostgreSQL documentation, please let
me know if I've done it right or if I should change something.

Yours truly,
Aleksey

On Sat, Jan 8, 2011 at 7:58 AM, Aleksey Tsalolikhin
<atsaloli(dot)tech(at)gmail(dot)com> wrote:
> 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
>