Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2 - Mailing list pgsql-general

From Ray O'Donnell
Subject Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2
Date
Msg-id 92a3e60e-b6d4-df7f-bad9-55e29adc5263@rodonnell.ie
Whole thread Raw
In response to Performance comparison between Pgsql 10.5 and Pgsql 11.2  (Nicola Contu <nicola.contu@gmail.com>)
Responses Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2  (Thomas Munro <thomas.munro@gmail.com>)
List pgsql-general
Tree view 
On 01/03/2019 15:01, Nicola Contu wrote:
> Hello,
> is there any reason why I am getting worse results using pgsql11.2 in 
> writing comparing it with pgsql 10.6?
> 
> I have two Instances, both just restored, so no bloats.
> Running read queries I have pretty much same results, a little bit 
> better on pg11- Running writes the difference is in favour of 10.

Did you run ANALYZE on the databases after restoring?

Ray.



-- 
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie

pgsql-general by date:

Previous
From: Jean-Philippe Chenel
Date:
Subject: RE: PostgreSQL (linux) configuration with GSSAPI to a Windows domain
Next
From: Andre Piwoni
Date:
Subject: Re: PostgreSQL (linux) configuration with GSSAPI to a Windows domain