Re: vacuumdb did not analyze all tables?=

2023-12-14 Thread Ron Johnson
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? ) >> >>

Re: vacuumdb did not analyze all tables?=

2023-12-14 Thread David G. Johnston
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?=

2023-12-14 Thread pf
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?=

2023-12-14 Thread Ron Johnson
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?=

2023-12-14 Thread Francisco Olarte
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: Increased storage size of jsonb in pg15

2023-12-14 Thread David G. Johnston
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

Re: Increased storage size of jsonb in pg15

2023-12-14 Thread Adrian Klaver
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

Re: how can I fix my accent issues?

2023-12-14 Thread Igniris Valdivia Baez
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

Re: Increased storage size of jsonb in pg15

2023-12-14 Thread Sean Flaherty
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