Re: vacuumdb did not analyze all tables?=
Francisco Olarte <folarte@peoplecall.com>
From: Francisco Olarte <folarte@peoplecall.com>
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Date: 2023-12-14T17:19:46Z
Lists: pgsql-general
Ron: On Thu, 14 Dec 2023 at 03:39, Ron Johnson <ronljohnsonjr@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? ) the interesting names, so quoted vacuumdb line is useless for check. Francisco Olarte.