Commitab3bb9c

committed

Add some real documentation about TOAST (finally). Combine this with

the old 'page' chapter and the recently added 'filelayout' chapter tomake a coherent chapter about PostgreSQL's physical storage layout.

1 parent521e888 commitab3bb9cCopy full SHA for ab3bb9c

File tree

+704

-535

lines changed

+704

-535

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$PostgreSQL: pgsql/doc/src/sgml/diskusage.sgml,v 1.13 2004/12/28 19:08:58 tgl Exp $`
	`2`	`+$PostgreSQL: pgsql/doc/src/sgml/diskusage.sgml,v 1.14 2005/01/10 00:04:38 tgl Exp $`
`3`	`3`	`-->`
`4`	`4`
`5`	`5`	`<chapter id="diskusage">`
`@@ -22,12 +22,12 @@ $PostgreSQL: pgsql/doc/src/sgml/diskusage.sgml,v 1.13 2004/12/28 19:08:58 tgl Ex`
`22`	`22`	`stored. If the table has any columns with potentially-wide values,`
`23`	`23`	`there is also a <acronym>TOAST</> file associated with the table,`
`24`	`24`	`which is used to store values too wide to fit comfortably in the main`
`25`		`- table. There will be one index on the`
	`25`	`+ table (see <xref linkend="storage-toast">). There will be one index on the`
`26`	`26`	`<acronym>TOAST</> table, if present. There may also be indexes associated`
`27`	`27`	`with the base table. Each table and index is stored in a separate disk`
`28`	`28`	`file — possibly more than one file, if the file would exceed one`
`29`	`29`	`gigabyte. Naming conventions for these files are described in <xref`
`30`		`- linkend="file-layout">.`
	`30`	`+ linkend="storage-file-layout">.`
`31`	`31`	`</para>`
`32`	`32`
`33`	`33`	`<para>`

Lines changed: 0 additions & 161 deletions

This file was deleted.

Lines changed: 2 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,4 @@`
`1`		`-<!-- $PostgreSQL: pgsql/doc/src/sgml/filelist.sgml,v 1.40 2004/12/03 05:50:18 momjian Exp $ -->`
	`1`	`+<!-- $PostgreSQL: pgsql/doc/src/sgml/filelist.sgml,v 1.41 2005/01/10 00:04:38 tgl Exp $ -->`
`2`	`2`
`3`	`3`	`<!entity history SYSTEM "history.sgml">`
`4`	`4`	`<!entity info SYSTEM "info.sgml">`
`@@ -75,15 +75,14 @@`
`75`	`75`	`<!entity arch-dev SYSTEM "arch-dev.sgml">`
`76`	`76`	`<!entity bki SYSTEM "bki.sgml">`
`77`	`77`	`<!entity catalogs SYSTEM "catalogs.sgml">`
`78`		`-<!entity filelayout SYSTEM "filelayout.sgml">`
`79`	`78`	`<!entity geqo SYSTEM "geqo.sgml">`
`80`	`79`	`<!entity gist SYSTEM "gist.sgml">`
`81`	`80`	`<!entity indexcost SYSTEM "indexcost.sgml">`
`82`	`81`	`<!entity nls SYSTEM "nls.sgml">`
`83`		`-<!entity page SYSTEM "page.sgml">`
`84`	`82`	`<!entity plhandler SYSTEM "plhandler.sgml">`
`85`	`83`	`<!entity protocol SYSTEM "protocol.sgml">`
`86`	`84`	`<!entity sources SYSTEM "sources.sgml">`
	`85`	`+<!entity storage SYSTEM "storage.sgml">`
`87`	`86`
`88`	`87`	`<!-- appendixes -->`
`89`	`88`	`<!entity contacts SYSTEM "contacts.sgml">`

Lines changed: 6 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$PostgreSQL: pgsql/doc/src/sgml/lobj.sgml,v 1.35 2005/01/08 22:13:33 tgl Exp $`
	`2`	`+$PostgreSQL: pgsql/doc/src/sgml/lobj.sgml,v 1.36 2005/01/10 00:04:38 tgl Exp $`
`3`	`3`	`-->`
`4`	`4`
`5`	`5`	`<chapter id="largeObjects">`
`@@ -51,9 +51,11 @@ $PostgreSQL: pgsql/doc/src/sgml/lobj.sgml,v 1.35 2005/01/08 22:13:33 tgl Exp $`
`51`	`51`	`</para>`
`52`	`52`
`53`	`53`	`<para>`
`54`		`- <indexterm><primary>TOAST</></>`
`55`		`- <indexterm><primary>sliced bread</><see>TOAST</></indexterm>`
`56`		`- <productname>PostgreSQL 7.1</productname> introduced a mechanism`
	`54`	`+ <indexterm>`
	`55`	`+ <primary>TOAST</primary>`
	`56`	`+ <secondary>versus large objects</secondary>`
	`57`	`+ </indexterm>`
	`58`	`+ <productname>PostgreSQL</productname> 7.1 introduced a mechanism`
`57`	`59`	`(nicknamed <quote><acronym>TOAST</acronym></quote>) that allows`
`58`	`60`	`data values to be much larger than single pages. This`
`59`	`61`	`makes the large object facility partially obsolete. One`

Comments

(0)