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

From Adrian Klaver
Subject Re: Does TOAST really compress the complete row?
Date
Msg-id f1817d2a-0300-bf7e-2b55-1883a8a1fd26@aklaver.com
Whole thread Raw
In response to Re: Does TOAST really compress the complete row?  (Adam Brusselback <adambrusselback@gmail.com>)
Responses Re: Does TOAST really compress the complete row?
List pgsql-general
On 7/2/20 4:29 PM, Adam Brusselback wrote:
> Another thing that was said I wasn't aware of and have not been able to 
> find any evidence to support:

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

> 
>  > 10. Blobs don’t participate in Logical replication.


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Adam Brusselback
Date:
Subject: Re: Does TOAST really compress the complete row?
Next
From: Adam Brusselback
Date:
Subject: Re: Does TOAST really compress the complete row?