Re: Poor Performance running Django unit tests after upgrading from 10.6

2020-10-15 Thread Tom Lane
Roger Hunwicks writes: > ... > However, even though we have similar performance for 12.4 for most > test runs, it remains very variable. > ... > I think we have narrowed down the problem to a single, very complex, > materialized view using CTEs; the unit tests create the test data and > then refre

Re: Poor Performance running Django unit tests after upgrading from 10.6

2020-10-15 Thread Andrew Dunstan
On 10/15/20 1:21 AM, Roger Hunwicks wrote: > > I think we have narrowed down the problem to a single, very complex, > materialized view using CTEs; the unit tests create the test data and > then refresh the materialized view before executing the actual test > code. > Have you checked to see if

Re: Poor Performance running Django unit tests after upgrading from 10.6

2020-10-14 Thread Laurenz Albe
On Thu, 2020-10-15 at 01:21 -0400, Roger Hunwicks wrote: > We have a large Django application running against a Postgresql database. > > When we run the test suite using Postgresql 10.7 in a Docker container > we consistently get: > > Ran 1166 tests in 1291.855s > > When we first started running