From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Precompressed data in TOASTed columns (was Re: Regarding postgreSQL performance on DRAM) |
Date: | 2019-02-21 00:38:20 |
Message-ID: | d01fb828-72cb-83ea-d69a-62f80cb4dc6d@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On 2/20/19 3:04 PM, Tom Lane wrote:
[snip]
> Well, the entire tuple would be 25600 bytes plus some overhead, which
> cannot fit on a Postgres page (8K, unless the OP changed compile options
> without mentioning it). So something has to be done to make it fit, and
> that something is going to be toasting any fields that can be toasted.
>
> From memory, our threshold for trying to make tuples narrower is only
> a quarter-page anyway, so that the toaster will be trying to get this
> down to 2K if it can. That's certainly going to involve compressing
> every field, and I wouldn't be surprised if a lot of them get shoved
> out-of-line too.
>
> The OP might care to read
>
> https://www.postgresql.org/docs/current/storage-toast.html
Based on that and https://www.postgresql.org/docs/9.6/sql-altertable.html
should I think about doing a SET STORAGE=EXTERNAL on columns with PDF and
compressed TIFF data?
Thanks
--
Angular momentum makes the world go 'round.
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Steben | 2019-02-21 12:42:27 | Moving postgres 9.4 databases to new vm hosted datacenter |
Previous Message | Rohan Kadekodi | 2019-02-20 21:50:51 | Re: Regarding postgreSQL performance on DRAM |