| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | HORDER Philip <Phil(dot)Horder(at)uk(dot)thalesgroup(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Restore of a reference database kills the auto analyze processing. |
| Date: | 2024-05-07 15:28:59 |
| Message-ID: | 399d1e23-db29-4dda-be55-8be41db48d3d@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Siddharth Jain | 2024-05-07 16:48:38 | Re: Question regarding how databases support atomicity |
| Previous Message | Adrian Klaver | 2024-05-07 15:24:29 | Re: Restore of a reference database kills the auto analyze processing. |