Feedback-ID: i76984098:Fastmail
Message-ID: <399d1e23-db29-4dda-be55-8be41db48d3d@aklaver.com>
Date: Tue, 7 May 2024 08:28:59 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Restore of a reference database kills the auto analyze
 processing.
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: HORDER Philip <Phil.Horder@uk.thalesgroup.com>,
 "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <5910d4dcbe244548bbf482dad0ceca83@uk.thalesgroup.com>
 <4b64d2cc-1df6-4982-b842-39fb0d886731@aklaver.com>
 <545ad7354f5f4c239df25faf8e883e98@uk.thalesgroup.com>
 <7c5b3f29-d82d-4cac-9aeb-8a4c0085ddf2@aklaver.com>
Content-Language: en-US
In-Reply-To: <7c5b3f29-d82d-4cac-9aeb-8a4c0085ddf2@aklaver.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/399d1e23-db29-4dda-be55-8be41db48d3d%40aklaver.com>
Precedence: bulk

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