I have a user table with ~8M records, with different type of fields b-tree indexed.
by investigating index sizes, i found two strange things:
1- all index sizes are almost the same, regardless of field type (boolean, string, bigint)
2 - all of them are much bigger that my expectation, e.g. for a boolean field, even after reindexing, the size is 217MB, so each record takes ~27 bytes.
could some one shed some light on this please? or refer any user oriented documentation about index size estimations
Чтобы сделать работу с сайтом удобнее, мы используем cookie и аналитический сервис «Яндекс.Метрика». Продолжая пользоваться сайтом, вы соглашаетесь с их использованием.