-Original Message-
From: Laurenz Albe
Sent: 07 January 2021 02:06
To: Rob Northcott ; pgsql-gene...@postgresql.org
Subject: Re: Keep needing to run manual analyze
On Wed, 2021-01-06 at 17:28 +, Rob Northcott wrote:
>> We have an application that uses a Postgres database (cur
From: Michael Lewis
Sent: 06 January 2021 18:11
To: Rob Northcott
Cc: pgsql-gene...@postgresql.org
Subject: Re: Keep needing to run manual analyze
On Wed, Jan 6, 2021 at 10:29 AM Rob Northcott
mailto:rob.northc...@compilator.com>> wrote:
We have an application that uses a Postgres da
On Wed, 2021-01-06 at 17:28 +, Rob Northcott wrote:
> We have an application that uses a Postgres database (currently 9.6). All
> the autovacuum/analyze settings are just left at the defaults.
> We’ve had a few instances recently where users have complained of slow
> performance and running
On Wed, Jan 6, 2021 at 10:29 AM Rob Northcott
wrote:
> We have an application that uses a Postgres database (currently 9.6). All
> the autovacuum/analyze settings are just left at the defaults.
>
> We’ve had a few instances recently where users have complained of slow
> performance and running a