| From: | Francisco Olarte <folarte(at)peoplecall(dot)com> |
|---|---|
| To: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: vacuumdb did not analyze all tables?= |
| Date: | 2023-12-14 17:19:46 |
| Message-ID: | CA+bJJbx9ngqNmehsw_bCsVFeKnb58JZ+Hk1Msf7BgZhuJoe8yw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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? ) the interesting names, so quoted vacuumdb line is useless
for check.
Francisco Olarte.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2023-12-14 18:10:16 | Re: vacuumdb did not analyze all tables?= |
| Previous Message | David G. Johnston | 2023-12-14 16:46:44 | Re: Increased storage size of jsonb in pg15 |