[pgpool-general: 8987] Re: vacuumdb did not analyze all tables?
Tatsuo Ishii
ishii at sraoss.co.jp
Thu Dec 14 06:51:11 JST 2023
I suggest to post the question to pgsql-general mailing list.
It seems there's nothing related to Pgpool-II.
Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
From: Ron Johnson <ronljohnsonjr at gmail.com>
Subject: [pgpool-general: 8986] vacuumdb did not analyze all tables?
Date: Wed, 13 Dec 2023 12:49:55 -0500
Message-ID: <CANzqJaB8=gvvvgcM=fr7ykw2cWNJCwsoG-aqNyZhFJKBvoDzkw at mail.gmail.com>
> vacuumdb 15.3
> database instance: 9.6.24
>
> I manually analyzed 71 tables this morning at 10:42. (All those with
> "rp20_y2021" in the relname.)
>
> Three of the 71 tables were not analyzed. Why would that be?
>
> (Five were not vacuumed, but I accept that some other process might have
> blocked them.)
>
> vacuumdb -U postgres -h $DbServer --analyze -j6 -t ... -t
> cds.cdstransaction_rp20_y2021 -t ...
>
> TAPb=# select schemaname||'.'||relname as table_name
> , last_vacuum
> , last_analyze
> from pg_stat_user_tables
> where schemaname||'.'||relname in ('cds.cdstransaction_rp20_y2021'
> , 'css.image_annotation_rp20_y2021'
> , 'tms.document_rp20_y2021')
> order by 1;
> table_name | last_vacuum |
> last_analyze
> ---------------------------------+-------------------------------+-------------------------------
> 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
> (3 rows)
More information about the pgpool-general
mailing list