From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | Francisco Olarte <folarte(at)peoplecall(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: vacuumdb did not analyze all tables?= |
Date: | 2023-12-14 18:10:16 |
Message-ID: | CANzqJaCOJBRw4nNTbXS8C4YgFjhpHNhE9rJGUo9hcMyNpcrvPQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Dec 14, 2023 at 12:20 PM Francisco Olarte <folarte(at)peoplecall(dot)com>
wrote:
> Ron:
>
> On Thu, 14 Dec 2023 at 03:39, Ron Johnson <ronljohnsonjr(at)gmail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | pf | 2023-12-15 00:46:16 | Re: vacuumdb did not analyze all tables?= |
Previous Message | Francisco Olarte | 2023-12-14 17:19:46 | Re: vacuumdb did not analyze all tables?= |