1 Answer
- Newest
- Most votes
- Most comments
0
Resolution from the AWS support ticket:
The change in storage size of jsonb data type columns is caused by different toast compression methods. Since Postgres 15, default toast compression method used in RDS is 'lz4', while RDS Postgres 14 uses 'pglz'.
If you want to use a different compression method for individual columns, you can specify the compression method by setting the COMPRESSION column option in 'CREATE TABLE' or 'ALTER TABLE' commands [1].
Alternatively, you could modify your parameter group [2] to use a different default toast compression method [3] by modifying the parameter “default_toast_compression”.
answered 4 months ago
Relevant content
- Accepted Answerasked 9 months ago
- asked 4 months ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated 9 months ago
- AWS OFFICIALUpdated a year ago
We have opened up a support ticket with AWS regarding this issue. They have been able to reproduce the issue. Currently, waiting on additional information from them.