A
A
Aristes2016-05-24 20:51:13
linux
Aristes, 2016-05-24 20:51:13

Can PostgreSQL indexes weigh that much?

There is a table consisting of 9 columns where there are bigserial, boolean, timestamp and the rest are integers. Its size is 55 GB. It has 5 indexes on bigserial, boolean, timestamp and two integer fields. Indexes weigh 137 GB.
Are the indexes bloated?
ZY: in search of the truth - why requests slow down ...

Answer the question

In order to leave comments, you need to log in

1 answer(s)
L
lega, 2016-05-24
@Aristes

norm indexes, and you need to use partitioning

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question