On 5/7/24 08:24, Adrian Klaver wrote:
> On 5/7/24 02:38, HORDER Philip wrote:
>> Thanks for your time Adrian
>>
>>
>
> 1) What is the exact pg_restore command you are using?
>
> 2) From earlier post: '... only analyzes tables in the new db at the
> point of reload, then shuts off again.' Provide that sequence of events
> from the Postgres log.
>
> 3) Also statistics from
>
> https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-PG-STAT-ALL-TABLES-VIEW
>
> for that table after the reload.
4) The autovacuum settings you have in effect.
--
Adrian Klaver
adrian.klaver@aklaver.com