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.t...@gmail.com> wrote: > On Sat, Jan 8, 2011 at 3:16 AM, Robert Haas <robertmh...@gmail.com> wrote: >> On Wed, Dec 22, 2010 at 9:05 PM, Aleksey Tsalolikhin >> <atsaloli.t...@gmail.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 > -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs