Postgres Pro
Downloads
Home   >   mailing lists

Re: Does TOAST really compress the complete row? - Mailing list pgsql-general

From Adam Brusselback
Subject Re: Does TOAST really compress the complete row?
Date
Msg-id CAMjNa7fQfKirZOZjzbht1za7mAvj3DLzpGpxgWqVaH3UxMWotw@mail.gmail.com
Whole thread Raw
In response to Re: Does TOAST really compress the complete row?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
> https://www.postgresql.org/docs/12/logical-replication-restrictions.html
> 
> "Large objects (see Chapter 34) are not replicated. There is no 
> workaround for that, other than storing data in normal tables."
> 
> Of course that does not apply to bytea:
> 
> https://www.postgresql.org/docs/12/datatype-binary.html

That makes sense now, I was reading that section as if it were talking about bytea, not LO. 

Thanks for pointing that out!
- Adam

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Does TOAST really compress the complete row?
Next
From: Laurenz Albe
Date:
Subject: Re: survey: psql syntax errors abort my transactions