Re: [GENERAL] Explain analyse and toasted data.

2017-08-24 Thread Tom Lane
=?UTF-8?Q?Benoit_Lobr=C3=A9au?= writes: > In this video (PostgreSQL at 10 TB and beyond: https://youtu.be/8mKpfutwD0U > at 6mn05), the speaker says that on very big databases explain analyse can > give unrealistic results because it doesn't read toasted data. > I suppose it's because of this: "Th

[GENERAL] Explain analyse and toasted data.

2017-08-24 Thread Benoit Lobréau
Hi, In this video (PostgreSQL at 10 TB and beyond: https://youtu.be/8mKpfutwD0U at 6mn05), the speaker says that on very big databases explain analyse can give unrealistic results because it doesn't read toasted data. I suppose it's because of this: "The big values of TOASTed attributes will only