From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Sean Flaherty <sflaherty(at)grndwork(dot)com> |
Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Increased storage size of jsonb in pg15 |
Date: | 2023-12-14 16:46:44 |
Message-ID: | CAKFQuwb7z+y8ZmmMuTC6Kt+USNRGx2WutHt8QmgAw+MSPXKQcA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Dec 14, 2023 at 7:48 AM Sean Flaherty <sflaherty(at)grndwork(dot)com>
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> version "8.8.0" to create the
> json objects and insert the data records as jsonb data.
>
> None of the upload process changed during the underlying database upgrade.
>
Basic debugging requires the existence of a self-contained reproducer. In
this case ideally one that only uses psql and some static (already
processed) data files, and that is known to produce the observed behaviors
on non-RDS PostgreSQL.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Olarte | 2023-12-14 17:19:46 | Re: vacuumdb did not analyze all tables?= |
Previous Message | Adrian Klaver | 2023-12-14 16:16:09 | Re: Increased storage size of jsonb in pg15 |