summaryrefslogtreecommitdiff
path: root/doc/development/ordering_table_columns.md
diff options
context:
space:
mode:
authorEvan Read <eread@gitlab.com>2019-01-24 06:52:33 +0000
committerAchilleas Pipinellis <axil@gitlab.com>2019-01-24 06:52:33 +0000
commitc2c2d04b3a0d7942edd8c8608f6bd25428131fc3 (patch)
tree361f2da1a8509a669bec9887abe65252afea5ac2 /doc/development/ordering_table_columns.md
parent7d11049237cca35307b996dcec683693794c831a (diff)
downloadgitlab-ce-c2c2d04b3a0d7942edd8c8608f6bd25428131fc3.tar.gz
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.md7
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.