Patrick B wrote:
> I have a database which is 4TB big. We currently store binary data in a bytea
> data type column
> (seg_data BYTEA). The column is behind binary_schema and the files types
> stored are: pdf, jpg, png.
> Questions:
>
> 1 - If I take out 500GB of bytea data ( by updating the co
Hi all.
I have a database which is 4TB big. We currently store binary data in a
bytea data type column (seg_data BYTEA). The column is behind binary_schema
and the files types stored are: pdf, jpg, png.
*Getting the schema binary_schema size:*
SELECT pg_size_pretty(pg_database_size('live_databa
