Adrian Klaver
wrote:
> On 12/29/23 07:21, Sean Flaherty wrote:
> > What we found is that using lz4 compression on JSONB data is 20-25%
> > larger on disk than pglz. We are running a production workload that is
> > storing jsonb data with a focus read performance. The documented
What we found is that using lz4 compression on JSONB data is 20-25% larger
on disk than pglz. We are running a production workload that is storing
jsonb data with a focus read performance. The documented increase in write
speed wasn't a large benefit, however, the increase in storage size moved
I'm rather new to the mailing list, are there any additional steps I should
take (i.e. posting to pgsql-hackers, etc.)?
On Thu, Dec 28, 2023 at 11:23 AM Adrian Klaver
wrote:
> On 12/28/23 09:13, Sean Flaherty wrote:
> > Follow-up:
> > Working with AWS, we found that starting in
, 2023 at 1:56 PM Adrian Klaver
wrote:
> On 12/15/23 12:43, Sean Flaherty wrote:
> > We did a little more digging on our side, which I apologize for not
> > doing beforehand.
> >
> > We wrote a script to create a simple table with a jsonb column, inserted
> &g
<
david.g.johns...@gmail.com> wrote:
> On Thu, Dec 14, 2023 at 7:48 AM Sean Flaherty
> wrote:
>
>> We have a process that runs once an hour to read the .dat file in csv
>> format then a node script using the pg package
>> <https://github.com/brianc/node-postgres>
s changed during the underlying database upgrade.
On Wed, Dec 13, 2023 at 4:56 PM Adrian Klaver
wrote:
> On 12/13/23 15:49, Sean Flaherty wrote:
> > More information needed:
> >
>
> > 2) An example of reported size for the 14.? and 15.5 cases.
> >
> >
No differences.
4) Was this done on same machine? If not how are the machines different?
Same AWS RDS Postgres instance.
5) How the upgrade was done?
Using the AWS RDS upgrade.
On Wed, Dec 13, 2023 at 3:21 PM Adrian Klaver
wrote:
> On 12/13/23 14:07, Sean Flaherty wrote:
>
Hello,
We are seeing an increase in the reported storage size of our jsonb columns
(using pg_column_size) since upgrading to Postgres 15.5 from version 14.
The increase in size is enough to push us over the size threshold and more
of our data to get written to the TOAST table.
I can't find any
