Re: vacuumdb did not analyze all tables?=

Поиск
Список
Период
Сортировка
От Francisco Olarte
Тема Re: vacuumdb did not analyze all tables?=
Дата
Msg-id CA+bJJbx9ngqNmehsw_bCsVFeKnb58JZ+Hk1Msf7BgZhuJoe8yw@mail.gmail.com
обсуждение исходный текст
Ответ на vacuumdb did not analyze all tables?=  (Ron Johnson <ronljohnsonjr@gmail.com>)
Ответы Re: vacuumdb did not analyze all tables?=
Список 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.



В списке pgsql-general по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Increased storage size of jsonb in pg15
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: vacuumdb did not analyze all tables?=