Re: Aurora Postgresql RDS DB Latency

2019-02-12 Thread github kran
On Mon, Feb 11, 2019 at 6:00 PM github kran wrote: > > > On Mon, Feb 11, 2019 at 3:29 PM Michael Lewis wrote: > >> Are default statistics target the same on both prod and AWS? Have you >> analyzed all tables being used in this query to ensure stats are up proper? >> If the optimizer is choosing

Re: Aurora Postgresql RDS DB Latency

2019-02-11 Thread github kran
On Mon, Feb 11, 2019 at 3:29 PM Michael Lewis wrote: > Are default statistics target the same on both prod and AWS? Have you > analyzed all tables being used in this query to ensure stats are up proper? > If the optimizer is choosing a different plan, then the stats must be > different IMO. > > >

Re: Aurora Postgresql RDS DB Latency

2019-02-11 Thread Michael Lewis
Are default statistics target the same on both prod and AWS? Have you analyzed all tables being used in this query to ensure stats are up proper? If the optimizer is choosing a different plan, then the stats must be different IMO. *Michael Lewis | Software Engineer* *Entrata* On Mon, Feb 11, 2

Aurora Postgresql RDS DB Latency

2019-02-11 Thread github kran
Hi Postgres Team, We are using AWS Aurora RDS Postgres DB 9.6.8 Engine. We recently deleted few million rows from the database and ran into a issue in one of our dev account where the DB was not normal after this deletion. We did re index, vacuuming entire database but we couldnt bring it to the sa