News for hackers. Stuff that matters.

A comment on PostgreSQL 9.6 Released. Parent comment

Re:PostgreSQL 9.6 Released by ngrilly on Thursday September 29, 2016 @07:10PM (#12609527)
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.

[ Parent | on HN ]
Re:PostgreSQL 9.6 Released by combatentropy on Thursday September 29, 2016 @07:51PM (#12609680)
Whoops! Yes, there is a corresponding TOAST table that I had to track down.

  Table: 341 MB (main table + TOAST table)
  Index: 100 MB
[ Parent | on HN ]