Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2

From: Ray O'Donnell <ray(at)rodonnell(dot)ie>
To: Nicola Contu <nicola(dot)contu(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Cc: Alessandro Aste <Alessandro(dot)aste(at)gtt(dot)net>
Subject: Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2
Date: 2019-03-01 16:01:57
Message-ID: 92a3e60e-b6d4-df7f-bad9-55e29adc5263@rodonnell.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)rodonnell(dot)ie

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andre Piwoni 2019-03-01 16:44:05 Re: PostgreSQL (linux) configuration with GSSAPI to a Windows domain
Previous Message Jean-Philippe Chenel 2019-03-01 15:59:28 RE: PostgreSQL (linux) configuration with GSSAPI to a Windows domain