File tree Expand file tree Collapse file tree 2 files changed +28
-5
lines changed Expand file tree Collapse file tree 2 files changed +28
-5
lines changed Original file line number Diff line number Diff line change 2
2
PostgreSQL TODO List
3
3
====================
4
4
Current maintainer: Bruce Momjian (bruce@momjian.us)
5
- Last updated: Tue Sep 12 17:02:34 EDT 2006
5
+ Last updated: Thu Sep 14 13:11:44 EDT 2006
6
6
7
7
The most recent version of this document can be viewed at
8
8
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -1350,9 +1350,22 @@ Miscellaneous Performance
1350
1350
1351
1351
* Consider ways of storing rows more compactly on disk
1352
1352
1353
- o Store disk pages with no alignment/padding?
1354
1353
o Reorder physical storage order to reduce padding?
1354
+
1355
+ This involves having the user-specified order of columns
1356
+ be different from the physical order. SELECT * would
1357
+ need to reorder the physical values to match the
1358
+ user-specified ordering.
1359
+
1360
+ o Store disk pages with no alignment/padding?
1361
+
1362
+ This necessitates adding CPU-required padding when moving
1363
+ rows from disk to memory.
1364
+
1355
1365
o Support a smaller header for short variable-length fields?
1366
+
1367
+ http://archives.postgresql.org/pgsql-hackers/2006-09/msg00848.php
1368
+
1356
1369
o Reduce the row header size?
1357
1370
1358
1371
Original file line number Diff line number Diff line change 8
8
< body bgcolor ="#FFFFFF " text ="#000000 " link ="#FF0000 " vlink ="#A00000 " alink ="#0000FF ">
9
9
< h1 > < a name ="section_1 "> PostgreSQL TODO List</ a > </ h1 >
10
10
< p > Current maintainer: Bruce Momjian (< a href ="mailto:bruce@momjian.us "> bruce@momjian.us</ a > )< br />
11
- Last updated: Tue Sep 12 17:02:34 EDT 2006
11
+ Last updated: Thu Sep 14 13:11:44 EDT 2006
12
12
</ p >
13
13
< p > The most recent version of this document can be viewed at< br />
14
14
< a href ="http://www.postgresql.org/docs/faqs.TODO.html "> http://www.postgresql.org/docs/faqs.TODO.html</ a > .
@@ -1217,9 +1217,19 @@ <h1><a name="section_21">Miscellaneous Performance</a></h1>
1217
1217
</ p >
1218
1218
</ li > < li > Consider ways of storing rows more compactly on disk
1219
1219
< ul >
1220
- < li > Store disk pages with no alignment/padding?
1221
- </ li > < li > Reorder physical storage order to reduce padding?
1220
+ < li > Reorder physical storage order to reduce padding?
1221
+ < p > This involves having the user-specified order of columns
1222
+ be different from the physical order. SELECT * would
1223
+ need to reorder the physical values to match the
1224
+ user-specified ordering.
1225
+ </ p >
1226
+ </ li > < li > Store disk pages with no alignment/padding?
1227
+ < p > This necessitates adding CPU-required padding when moving
1228
+ rows from disk to memory.
1229
+ </ p >
1222
1230
</ li > < li > Support a smaller header for short variable-length fields?
1231
+ < p > < a href ="http://archives.postgresql.org/pgsql-hackers/2006-09/msg00848.php "> http://archives.postgresql.org/pgsql-hackers/2006-09/msg00848.php</ a >
1232
+ </ p >
1223
1233
</ li > < li > Reduce the row header size?
1224
1234
</ li > </ ul >
1225
1235
</ li > </ ul >
You can’t perform that action at this time.
0 commit comments