diff options
author | Evan Read <eread@gitlab.com> | 2019-01-24 09:52:33 +0300 |
---|---|---|
committer | Achilleas Pipinellis <axil@gitlab.com> | 2019-01-24 09:52:33 +0300 |
commit | c2c2d04b3a0d7942edd8c8608f6bd25428131fc3 (patch) | |
tree | 361f2da1a8509a669bec9887abe65252afea5ac2 /doc/development/ordering_table_columns.md | |
parent | 7d11049237cca35307b996dcec683693794c831a (diff) |
Fix most instances of bare URLs in markdown
Diffstat (limited to 'doc/development/ordering_table_columns.md')
-rw-r--r-- | doc/development/ordering_table_columns.md | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/doc/development/ordering_table_columns.md b/doc/development/ordering_table_columns.md index e9c6481635b..3e49a65f5ab 100644 --- a/doc/development/ordering_table_columns.md +++ b/doc/development/ordering_table_columns.md @@ -30,7 +30,7 @@ ideal column order would be the following: - `user_id` (integer, 4 bytes) - `name` (text, variable) -or +or - `name` (text, variable) - `id` (integer, 4 bytes) @@ -47,8 +47,7 @@ type size in descending order with variable sizes (`text`, `varchar`, arrays, ## Type Sizes -While the PostgreSQL documentation -(https://www.postgresql.org/docs/current/static/datatype.html) contains plenty +While the [PostgreSQL documentation](https://www.postgresql.org/docs/current/datatype.html) contains plenty of information we will list the sizes of common types here so it's easier to look them up. Here "word" refers to the word size, which is 4 bytes for a 32 bits platform and 8 bytes for a 64 bits platform. @@ -138,7 +137,7 @@ This would produce the following chunks: | variable | data | Here we only need 40 bytes per row excluding the variable sized data and 24-byte -tuple header. 8 bytes being saved may not sound like much, but for tables as +tuple header. 8 bytes being saved may not sound like much, but for tables as large as the `events` table it does begin to matter. For example, when storing 80 000 000 rows this translates to a space saving of at least 610 MB, all by just changing the order of a few columns. |