RE: Keep needing to run manual analyze

2021-01-07 Thread Rob Northcott
-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

RE: Keep needing to run manual analyze

2021-01-07 Thread Rob Northcott
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

Re: Keep needing to run manual analyze

2021-01-06 Thread Laurenz Albe
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

Re: Keep needing to run manual analyze

2021-01-06 Thread Michael Lewis
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