Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2

Поиск
Список
Период
Сортировка
От Ray O'Donnell
Тема Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2
Дата
Msg-id 92a3e60e-b6d4-df7f-bad9-55e29adc5263@rodonnell.ie
обсуждение исходный текст
Ответ на Performance comparison between Pgsql 10.5 and Pgsql 11.2  (Nicola Contu <nicola.contu@gmail.com>)
Ответы Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2
Список 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@rodonnell.ie

В списке pgsql-general по дате отправления:

Предыдущее
От: Jean-Philippe Chenel
Дата:
Сообщение: RE: PostgreSQL (linux) configuration with GSSAPI to a Windows domain
Следующее
От: Andre Piwoni
Дата:
Сообщение: Re: PostgreSQL (linux) configuration with GSSAPI to a Windows domain