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

Commitbc6fb54

Browse files
committed
Update FAQ for new 24-byte header, down from 28.
1 parent1ad2f04 commitbc6fb54

File tree

2 files changed

+18
-18
lines changed

2 files changed

+18
-18
lines changed

‎doc/FAQ

Lines changed: 9 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11

22
Frequently Asked Questions (FAQ) for PostgreSQL
33

4-
Last updated:Tue Feb6 22:16:17 EST 2007
4+
Last updated:Thu Feb8 22:43:13 EST 2007
55

66
Current maintainer: Bruce Momjian (bruce@momjian.us)
77

@@ -547,25 +547,25 @@
547547
As an example, consider a file of 100,000 lines with an integer and
548548
text description on each line. Suppose the text string avergages
549549
twenty bytes in length. The flat file would be 2.8 MB. The size of the
550-
PostgreSQL database file containing this data can be estimated as 5.6
550+
PostgreSQL database file containing this data can be estimated as 5.2
551551
MB:
552-
28 bytes: each row header (approximate)
552+
24 bytes: each row header (approximate)
553553
24 bytes: one int field and one text field
554554
+ 4 bytes: pointer on page to tuple
555555
----------------------------------------
556-
56 bytes per row
556+
52 bytes per row
557557

558558
The data page size in PostgreSQL is 8192 bytes (8 KB), so:
559559

560560
8192 bytes per page
561-
------------------- =146 rows per database page (rounded down)
562-
56 bytes per row
561+
------------------- =158 rows per database page (rounded down)
562+
52 bytes per row
563563

564564
100000 data rows
565-
-------------------- =685 database pages (rounded up)
566-
146 rows per page
565+
-------------------- =633 database pages (rounded up)
566+
158 rows per page
567567

568-
685 database pages * 8192 bytes per page = 5,611,520 bytes (5.6 MB)
568+
633 database pages * 8192 bytes per page = 5,185,536 bytes (5.2 MB)
569569

570570
Indexes do not require as much overhead, but do contain the data that
571571
is being indexed, so they can be large also.

‎doc/src/FAQ/FAQ.html

Lines changed: 9 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -10,7 +10,7 @@
1010
alink="#0000ff">
1111
<H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>
1212

13-
<P>Last updated:Tue Feb6 22:16:17 EST 2007</P>
13+
<P>Last updated:Thu Feb8 22:43:13 EST 2007</P>
1414

1515
<P>Current maintainer: Bruce Momjian (<Ahref=
1616
"mailto:bruce@momjian.us">bruce@momjian.us</A>)
@@ -720,25 +720,25 @@ <H3 id="item4.5">4.5) How much database disk space is required
720720
and text description on each line. Suppose the text string
721721
avergages twenty bytes in length. The flat file would be 2.8 MB.
722722
The size of the PostgreSQL database file containing this data can
723-
be estimated as 5.6 MB:</P>
723+
be estimated as 5.2 MB:</P>
724724
<PRE>
725-
28 bytes: each row header (approximate)
725+
24 bytes: each row header (approximate)
726726
24 bytes: one int field and one text field
727727
+ 4 bytes: pointer on page to tuple
728728
----------------------------------------
729-
56 bytes per row
729+
52 bytes per row
730730

731731
The data page size in PostgreSQL is 8192 bytes (8 KB), so:
732732

733733
8192 bytes per page
734-
------------------- =146 rows per database page (rounded down)
735-
56 bytes per row
734+
------------------- =158 rows per database page (rounded down)
735+
52 bytes per row
736736

737737
100000 data rows
738-
-------------------- =685 database pages (rounded up)
739-
146 rows per page
738+
-------------------- =633 database pages (rounded up)
739+
158 rows per page
740740

741-
685 database pages * 8192 bytes per page = 5,611,520 bytes (5.6 MB)
741+
633 database pages * 8192 bytes per page = 5,185,536 bytes (5.2 MB)
742742
</PRE>
743743

744744
<P>Indexes do not require as much overhead, but do contain the data

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp