Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2
Дата
Msg-id CA+hUKGJXQ8Zg3Vy66-U7iCDjRqjkcH11+yCXxa=MEwLq+HZoAg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 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  (Nicola Contu <nicola.contu@gmail.com>)
Список pgsql-general
On Tue, Mar 5, 2019 at 5:01 AM Nicola Contu <nicola.contu@gmail.com> wrote:
> Attached a part of the strace running the pgbench command for pg11
> Also attached strace_10 for pg10.6.

That looks like strace output from pgbench, and I don't see any
interesting differences between v10 and v11 (though I'm surprised to
see it using poll() instead of ppoll(), and opening a new connection
for every transaction).

How about syscalls on the server side?  You could start it with
something like "strace -f path/to/postgres -D path/to/pgdata" (-f for
follow children), and perhaps also use -c so that it shows aggregated
data (up until you ^C it) instead of every syscall?

-- 
Thomas Munro
https://enterprisedb.com


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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Optimizing Database High CPU
Следующее
От: Perumal Raj
Дата:
Сообщение: Re: Question about pg_upgrade from 9.2 to X.X