Does TOAST really compress the complete row?

From: Thomas Kellerer <shammat(at)gmx(dot)net>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Does TOAST really compress the complete row?
Date: 2020-07-02 22:00:35
Message-ID: ec56843a-dd32-ed81-872d-f10247c8a7e0@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am confused about one claim in this blog post: https://www.2ndquadrant.com/en/blog/oracle-to-postgresql-binary-objects

> All columns that come after data > 2000 bytes participate in The
> Large Attribute Strorage Technique (TOAST). This storage is for the
> row, not the column. Your id column comes as the last column in the
> table? Whoopsie, your primary key just got shoved into blob storage
I always was under the impression that TOASTing only happens on column level, not on row level.
The manual does not mention anything about the whole row being TOASTed if one column exceeds the threshold.

Can someone clarify please?

Thomas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Anders Steinlein 2020-07-02 22:05:27 Re: Different results from identical matviews
Previous Message Tom Lane 2020-07-02 21:44:53 Re: Different results from identical matviews