On Thu, Dec 14, 2023 at 12:20 PM Francisco Olarte <fola...@peoplecall.com> wrote:
> Ron: > > On Thu, 14 Dec 2023 at 03:39, Ron Johnson <ronljohnso...@gmail.com> 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 | > 2023-11-17 04:11:08.761861-05 > > css.image_annotation_rp20_y2021 | 2023-09-25 20:00:07.831722-04 | > 2023-09-25 20:00:07.831793-04 > > tms.document_rp20_y2021 | 2023-12-13 10:42:03.079969-05 | > 2023-11-17 04:11:56.583881-05 > > I'm not sure if you kept the line, but you have ellipsed-out ( is that > a word? ) I think so. > the interesting names, so quoted vacuumdb line is useless > for check. 71 tables were listed, and didn't want to flood my email with a KB or two of non-essential text. I verified that all three tables were in the vacuumdb command line. (The list was generated by a query, and stdout and stderr were redirected to a file, and I grepped it for the table names.) If you want, I can attach the log file.