Re: postgres 9.3 vs. 9.4

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Re: postgres 9.3 vs. 9.4
Дата
Msg-id 541BCC93.9070204@catalyst.net.nz
обсуждение исходный текст
Ответ на Re: postgres 9.3 vs. 9.4  ("Mkrtchyan, Tigran" <tigran.mkrtchyan@desy.de>)
Ответы Re: postgres 9.3 vs. 9.4
Список pgsql-performance
On 19/09/14 17:53, Mkrtchyan, Tigran wrote:
>
>
> ----- Original Message -----
>> From: "Mark Kirkwood" <mark.kirkwood@catalyst.net.nz>

>> Further to the confusion, here's my 9.3 vs 9.4 on two M550 (one for 9.3
>> one for 9.4), see below for results.
>>
>> I'm running xfs on them with trim/discard enabled:
>>
>> $ mount|grep pg
>> /dev/sdd4 on /mnt/pg94 type xfs (rw,discard)
>> /dev/sdc4 on /mnt/pg93 type xfs (rw,discard)
>>
>>
>> I'm *not* seeing any significant difference between 9.3 and 9.4, and the
>> numbers are both about 2x your best number, which is food for thought
>> (those P320's should toast my M550 for write performance...).
>
> cool! any details on OS and other options? I still get the same numbers
> as before.
>

Sorry, Ubuntu 14.04 on a single socket i7 3.4 Ghz, 16G (i.e my workstation).

I saw the suggestion that Didier made to run 9.3 on the SSD that you
were using for 9.4, and see if it suddenly goes slow - then we'd know
it's something about the disk (or filesystem/mount options). Can you
test this?

Cheers

Mark


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

Предыдущее
От: "Mkrtchyan, Tigran"
Дата:
Сообщение: Re: postgres 9.3 vs. 9.4
Следующее
От: "Mkrtchyan, Tigran"
Дата:
Сообщение: Re: postgres 9.3 vs. 9.4