Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitc33bfb8

Browse files
committed
Update storage.sgml to describe the 9.0 tablespace directory layout.
1 parent1c72614 commitc33bfb8

File tree

1 file changed

+16
-6
lines changed

1 file changed

+16
-6
lines changed

‎doc/src/sgml/storage.sgml

Lines changed: 16 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -174,8 +174,6 @@ adjusted using the configuration option <option>--with-segsize</option>
174174
when building <productname>PostgreSQL</>.)
175175
In principle, free space map and visibility map forks could require multiple
176176
segments as well, though this is unlikely to happen in practice.
177-
The contents of tables and indexes are discussed further in
178-
<xref linkend="storage-page-layout">.
179177
</para>
180178

181179
<para>
@@ -187,15 +185,27 @@ its <acronym>TOAST</> table, if any.
187185
See <xref linkend="storage-toast"> for more information.
188186
</para>
189187

188+
<para>
189+
The contents of tables and indexes are discussed further in
190+
<xref linkend="storage-page-layout">.
191+
</para>
192+
190193
<para>
191194
Tablespaces make the scenario more complicated. Each user-defined tablespace
192195
has a symbolic link inside the <varname>PGDATA</><filename>/pg_tblspc</>
193-
directory, which points to the physical tablespace directory (as specified in
194-
its <command>CREATE TABLESPACE</> command). The symbolic link is named after
196+
directory, which points to the physical tablespace directory (i.e., the
197+
location specified in the tablespace's <command>CREATE TABLESPACE</> command).
198+
This symbolic link is named after
195199
the tablespace's OID. Inside the physical tablespace directory there is
200+
a subdirectory with a name that depends on the <productname>PostgreSQL</>
201+
server version, such as <literal>PG_9.0_201008051</>. (The reason for using
202+
this subdirectory is so that successive versions of the database can use
203+
the same <command>CREATE TABLESPACE</> location value without conflicts.)
204+
Within the version-specific subdirectory, there is
196205
a subdirectory for each database that has elements in the tablespace, named
197-
after the database's OID. Tables within that directory follow the filenode
198-
naming scheme. The <literal>pg_default</> tablespace is not accessed through
206+
after the database's OID. Tables and indexes are stored within that
207+
directory, using the filenode naming scheme.
208+
The <literal>pg_default</> tablespace is not accessed through
199209
<filename>pg_tblspc</>, but corresponds to
200210
<varname>PGDATA</><filename>/base</>. Similarly, the <literal>pg_global</>
201211
tablespace is not accessed through <filename>pg_tblspc</>, but corresponds to

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp