Understanding caching in Postgres – An in-depth guide (2016)

Re:Understanding caching in Postgres – An in-depth guide (2016) by thinkMOAR on Monday October 02, 2017 @06:04AM (#15382756)

It would also be interesting to see the tests (re-)done or compared vs new postgresql 10.

[ Parent | on HN ]

Re:Understanding caching in Postgres – An in-depth guide (2016) by madhusudhan000 on Monday October 02, 2017 @09:00AM (#15383428)

It hasn't changed much. But new OLAP features have come up such as parallel queries and for those, the existing cache architecture doesn't make sense since OLAP is full of sequential scans.

You can read the doc for the same - https://www.postgresql.org/docs/10/static/when-can-parallel-...

[ Parent | on HN ]

Re:Understanding caching in Postgres – An in-depth guide (2016) by thinkMOAR on Tuesday October 03, 2017 @03:54AM (#15390879)

Thanks for the feedback. Interesting nonetheless, thanks for the link

[ Parent | on HN ]