| 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 |