← Back to branch summary

~ubuntu-branches/ubuntu/oneiric/postgresql-9.1/oneiric-security

« back to all changes in this revision

Viewing changes to doc/src/sgml/html/lo-intro.html

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2011-05-11 10:41:53 UTC
  • Revision ID: james.westby@ubuntu.com-20110511104153-psbh2o58553fv1m0
Tags: upstream-9.1~beta1
Import upstream version 9.1~beta1

Show diffs side-by-side

added added

removed removed

Lines of Context:
doc/src/sgml/html/lo-intro.html
 
1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 
2
<HTML
 
3
><HEAD
 
4
><TITLE
 
5
>Introduction</TITLE
 
6
><META
 
7
NAME="GENERATOR"
 
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
 
9
REV="MADE"
 
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
 
11
REL="HOME"
 
12
TITLE="PostgreSQL 9.1beta1 Documentation"
 
13
HREF="index.html"><LINK
 
14
REL="UP"
 
15
TITLE="Large Objects"
 
16
HREF="largeobjects.html"><LINK
 
17
REL="PREVIOUS"
 
18
TITLE="Large Objects"
 
19
HREF="largeobjects.html"><LINK
 
20
REL="NEXT"
 
21
TITLE="Implementation Features"
 
22
HREF="lo-implementation.html"><LINK
 
23
REL="STYLESHEET"
 
24
TYPE="text/css"
 
25
HREF="stylesheet.css"><META
 
26
HTTP-EQUIV="Content-Type"
 
27
CONTENT="text/html; charset=ISO-8859-1"><META
 
28
NAME="creation"
 
29
CONTENT="2011-04-27T21:20:33"></HEAD
 
30
><BODY
 
31
CLASS="SECT1"
 
32
><DIV
 
33
CLASS="NAVHEADER"
 
34
><TABLE
 
35
SUMMARY="Header navigation table"
 
36
WIDTH="100%"
 
37
BORDER="0"
 
38
CELLPADDING="0"
 
39
CELLSPACING="0"
 
40
><TR
 
41
><TH
 
42
COLSPAN="5"
 
43
ALIGN="center"
 
44
VALIGN="bottom"
 
45
><A
 
46
HREF="index.html"
 
47
>PostgreSQL 9.1beta1 Documentation</A
 
48
></TH
 
49
></TR
 
50
><TR
 
51
><TD
 
52
WIDTH="10%"
 
53
ALIGN="left"
 
54
VALIGN="top"
 
55
><A
 
56
TITLE="Large Objects"
 
57
HREF="largeobjects.html"
 
58
ACCESSKEY="P"
 
59
>Prev</A
 
60
></TD
 
61
><TD
 
62
WIDTH="10%"
 
63
ALIGN="left"
 
64
VALIGN="top"
 
65
><A
 
66
TITLE="Large Objects"
 
67
HREF="largeobjects.html"
 
68
>Fast Backward</A
 
69
></TD
 
70
><TD
 
71
WIDTH="60%"
 
72
ALIGN="center"
 
73
VALIGN="bottom"
 
74
>Chapter 32. Large Objects</TD
 
75
><TD
 
76
WIDTH="10%"
 
77
ALIGN="right"
 
78
VALIGN="top"
 
79
><A
 
80
TITLE="Large Objects"
 
81
HREF="largeobjects.html"
 
82
>Fast Forward</A
 
83
></TD
 
84
><TD
 
85
WIDTH="10%"
 
86
ALIGN="right"
 
87
VALIGN="top"
 
88
><A
 
89
TITLE="Implementation Features"
 
90
HREF="lo-implementation.html"
 
91
ACCESSKEY="N"
 
92
>Next</A
 
93
></TD
 
94
></TR
 
95
></TABLE
 
96
><HR
 
97
ALIGN="LEFT"
 
98
WIDTH="100%"></DIV
 
99
><DIV
 
100
CLASS="SECT1"
 
101
><H1
 
102
CLASS="SECT1"
 
103
><A
 
104
NAME="LO-INTRO"
 
105
>32.1. Introduction</A
 
106
></H1
 
107
><P
 
108
>    All large objects are placed in a single system table called
 
109
    <CODE
 
110
CLASS="CLASSNAME"
 
111
>pg_largeobject</CODE
 
112
>.
 
113
    <SPAN
 
114
CLASS="PRODUCTNAME"
 
115
>PostgreSQL</SPAN
 
116
> also supports a storage system called
 
117
    <SPAN
 
118
CLASS="QUOTE"
 
119
>"<ACRONYM
 
120
CLASS="ACRONYM"
 
121
>TOAST</ACRONYM
 
122
>"</SPAN
 
123
> that automatically stores values
 
124
    larger than a single database page into a secondary storage area per table.
 
125
    This makes the large object facility partially obsolete.  One
 
126
    remaining advantage of the large object facility is that it allows values
 
127
    up to 2 GB in size, whereas <ACRONYM
 
128
CLASS="ACRONYM"
 
129
>TOAST</ACRONYM
 
130
>ed fields can be at
 
131
    most 1 GB.  Also, large objects can be randomly modified using a read/write
 
132
    API that is more efficient than performing such operations using
 
133
    <ACRONYM
 
134
CLASS="ACRONYM"
 
135
>TOAST</ACRONYM
 
136
>.
 
137
   </P
 
138
></DIV
 
139
><DIV
 
140
CLASS="NAVFOOTER"
 
141
><HR
 
142
ALIGN="LEFT"
 
143
WIDTH="100%"><TABLE
 
144
SUMMARY="Footer navigation table"
 
145
WIDTH="100%"
 
146
BORDER="0"
 
147
CELLPADDING="0"
 
148
CELLSPACING="0"
 
149
><TR
 
150
><TD
 
151
WIDTH="33%"
 
152
ALIGN="left"
 
153
VALIGN="top"
 
154
><A
 
155
HREF="largeobjects.html"
 
156
ACCESSKEY="P"
 
157
>Prev</A
 
158
></TD
 
159
><TD
 
160
WIDTH="34%"
 
161
ALIGN="center"
 
162
VALIGN="top"
 
163
><A
 
164
HREF="index.html"
 
165
ACCESSKEY="H"
 
166
>Home</A
 
167
></TD
 
168
><TD
 
169
WIDTH="33%"
 
170
ALIGN="right"
 
171
VALIGN="top"
 
172
><A
 
173
HREF="lo-implementation.html"
 
174
ACCESSKEY="N"
 
175
>Next</A
 
176
></TD
 
177
></TR
 
178
><TR
 
179
><TD
 
180
WIDTH="33%"
 
181
ALIGN="left"
 
182
VALIGN="top"
 
183
>Large Objects</TD
 
184
><TD
 
185
WIDTH="34%"
 
186
ALIGN="center"
 
187
VALIGN="top"
 
188
><A
 
189
HREF="largeobjects.html"
 
190
ACCESSKEY="U"
 
191
>Up</A
 
192
></TD
 
193
><TD
 
194
WIDTH="33%"
 
195
ALIGN="right"
 
196
VALIGN="top"
 
197
>Implementation Features</TD
 
198
></TR
 
199
></TABLE
 
200
></DIV
 
201
></BODY
 
202
></HTML
 
203
>
 
 
b'\\ No newline at end of file'