Re: question about postgres storage management
От | Christopher Browne |
---|---|
Тема | Re: question about postgres storage management |
Дата | |
Msg-id | CAFNqd5UpARCQ8Ug2D6Pu5dnkU2gaq7BMzC5XyOFqpRo4i_3+kw@mail.gmail.com обсуждение исходный текст |
Ответ на | question about postgres storage management (Will Childs-Klein <willck93@gmail.com>) |
Ответы |
Re: question about postgres storage management
|
Список | pgsql-hackers |
"Some operating systems implement compression at the file system level. Files are typically divided into fixed-size blocks that are compressed into variable-size blocks, which easily leads into fragmentation. Every time something inside a block is modified, the whole block is recompressed before it is written to disk. These properties make this compression technique unsuitable for use in an update-intensive database system."
You should avail yourself of the code on TOAST:
./src/backend/catalog/toasting.c
./src/backend/access/heap/tuptoaster.c
./src/include/catalog/toasting.h
./src/include/access/tuptoaster.h
./src/backend/catalog/toasting.c
./src/backend/access/heap/tuptoaster.c
./src/include/catalog/toasting.h
./src/include/access/tuptoaster.h
В списке pgsql-hackers по дате отправления: