Re: Relation extension scalability

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: Relation extension scalability
Дата
Msg-id CAA4eK1JWu5Xhmnpe2hOXw7WbHtBW6BacoiOMR106i2+Zv4xf8A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Relation extension scalability  (Petr Jelinek <petr@2ndquadrant.com>)
Ответы Re: Relation extension scalability  (Dilip Kumar <dilipbalaut@gmail.com>)
Список pgsql-hackers
Дерево обсуждения
On Tue, Mar 29, 2016 at 3:21 AM, Petr Jelinek <petr@2ndquadrant.com> wrote:
On 28/03/16 14:46, Dilip Kumar wrote:

    Conclusion:
    ---------------
    1. I think v15 is solving the problem exist with v13 and performance
    is significantly high compared to base, and relation size is also
    stable, So IMHO V15 is winner over other solution, what other thinks ?


 It seems so, do you have ability to reasonably test with 64 clients? I am mostly wondering if we see the performance going further down or just plateau.


Yes, that makes sense.  One more point is that if the reason for v13 giving better performance is extra blocks (which we believe in certain cases can leak till the time Vacuum updates the FSM tree), do you think it makes sense to once test by increasing lockWaiters * 20 limit to may be lockWaiters * 25 or lockWaiters * 30.


With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com

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

Предыдущее
От: Christian Ullrich
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Sync tzload() and tzparse() APIs with IANA release tzcode2016c.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [COMMITTERS] pgsql: pgbench: Support double constants and functions.