1 Respuesta
- Más nuevo
- Más votos
- Más comentarios
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”.
respondido hace 5 meses
Contenido relevante
- OFICIAL DE AWSActualizada hace 2 años
- OFICIAL DE AWSActualizada hace un año
- OFICIAL DE AWSActualizada hace 2 años
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.