File tree Expand file tree Collapse file tree 2 files changed +4
-4
lines changed Expand file tree Collapse file tree 2 files changed +4
-4
lines changed Original file line number Diff line number Diff line change 1
1
2
2
Frequently Asked Questions (FAQ) for PostgreSQL
3
3
4
- Last updated: Fri Feb 24 09:59:35 EST 2006
4
+ Last updated: Fri Feb 24 23:28:40 EST 2006
5
5
6
6
Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
7
7
524
524
As an example, consider a file of 100,000 lines with an integer and
525
525
text description on each line. Suppose the text string avergages
526
526
twenty bytes in length. The flat file would be 2.8 MB. The size of the
527
- PostgreSQL database file containing this data can be estimated as 6.4
527
+ PostgreSQL database file containing this data can be estimated as 5.6
528
528
MB:
529
529
28 bytes: each row header (approximate)
530
530
24 bytes: one int field and one text field
Original file line number Diff line number Diff line change 10
10
alink ="#0000ff ">
11
11
< H1 > Frequently Asked Questions (FAQ) for PostgreSQL</ H1 >
12
12
13
- < P > Last updated: Fri Feb 24 09:59:35 EST 2006</ P >
13
+ < P > Last updated: Fri Feb 24 23:28:40 EST 2006</ P >
14
14
15
15
< P > Current maintainer: Bruce Momjian (< A href =
16
16
"mailto:pgman@candle.pha.pa.us "> pgman@candle.pha.pa.us</ A > )
@@ -692,7 +692,7 @@ <H3 id="item4.5">4.5) How much database disk space is required
692
692
and text description on each line. Suppose the text string
693
693
avergages twenty bytes in length. The flat file would be 2.8 MB.
694
694
The size of the PostgreSQL database file containing this data can
695
- be estimated as 6.4 MB:</ P >
695
+ be estimated as 5.6 MB:</ P >
696
696
< PRE >
697
697
28 bytes: each row header (approximate)
698
698
24 bytes: one int field and one text field
You can’t perform that action at this time.
0 commit comments