4 ms·
Well this sort of explains the question I was thinking... which was how they would deal with such a massive table? At some point the indices will grow very lar
by scragg 14y ago
Well this sort of explains the question I was thinking... which was how they would deal with such a massive table? At some point the indices will grow very large and need to be split up some how or they won't fit in RAM.
- dotborg2 14y agoPostgres has feature called index partitioning, it solves such problems. There is also table partitioning. Creating/merging such tables and indexes should be done by your app automatically if you expect it to grow.