4 ms·
That's only 977 bytes per page (42 MB / 43,000 pages). Are you sure about the numbers? Maybe the plain-text body is stored in a TOAST table? Anyway, it looks l
by ngrilly 10y ago
That's only 977 bytes per page (42 MB / 43,000 pages). Are you sure about the numbers? Maybe the plain-text body is stored in a TOAST table?
Anyway, it looks like the whole dataset can fit in RAM, which explains the excellent performance, even with relevance ranking.
- combatentropy 10y agoWhoops! Yes, there is a corresponding TOAST table that I had to track down. Table: 341 MB (main table + TOAST table) Index: 100 MB