Re: Increased storage size of jsonb in pg15

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

Re: how can I fix my accent issues?

Hello to all, we have found the solution to our accents problem, a colleague of mine got the idea to use xlsx instead of xls and the magic happened, thanks to all for your support best regards El mié, 13 dic 2023 a las 0:19, Adrian Klaver () escribió: > > On 12/12/23 16:09, Igniris Valdivia Baez w

Re: Increased storage size of jsonb in pg15

On 12/14/23 06:48, 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 version "8.8.0" to create the json objects and insert the data records as jsonb data. Now I am

Re: Increased storage size of jsonb in pg15

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 > version "8.8.0" to create the > json objects and insert the data records as jso

Re: vacuumdb did not analyze all tables?=

Ron: On Thu, 14 Dec 2023 at 03:39, Ron Johnson wrote: ... > Three of the 71 tables were not analyzed. Why would that be? ... > vacuumdb -U postgres -h $DbServer --analyze -j6 -t ... -t > cds.cdstransaction_rp20_y2021 -t ... ... > cds.cdstransaction_rp20_y2021 | 2023-12-13 10:42:09.683143-05

Re: vacuumdb did not analyze all tables?=

On Thu, Dec 14, 2023 at 12:20 PM Francisco Olarte wrote: > Ron: > > On Thu, 14 Dec 2023 at 03:39, Ron Johnson wrote: > ... > > Three of the 71 tables were not analyzed. Why would that be? > ... > > vacuumdb -U postgres -h $DbServer --analyze -j6 -t ... -t > cds.cdstransaction_rp20_y2021 -t ...

Re: vacuumdb did not analyze all tables?=

On Thu, 14 Dec 2023 13:10:16 -0500 Ron Johnson wrote: >> I'm not sure if you kept the line, but you have ellipsed-out ( is that >> a word? ) ellipse: curve ellipsis: ...

Re: vacuumdb did not analyze all tables?=

On Thu, Dec 14, 2023 at 5:46 PM wrote: > On Thu, 14 Dec 2023 13:10:16 -0500 Ron Johnson wrote: > > >> I'm not sure if you kept the line, but you have ellipsed-out ( is that > >> a word? ) > > ellipse: curve > ellipsis: ... > > Though in contect "redacted" makes sense too. David J.

Re: vacuumdb did not analyze all tables?=

On Thu, Dec 14, 2023 at 7:51 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thu, Dec 14, 2023 at 5:46 PM wrote: > >> On Thu, 14 Dec 2023 13:10:16 -0500 Ron Johnson wrote: >> >> >> I'm not sure if you kept the line, but you have ellipsed-out ( is that >> >> a word? ) >> >> ellipse: