Re: Delay locking partitions during INSERT and UPDATE

Поиск
Список
Период
Сортировка
От John Naylor
Тема Re: Delay locking partitions during INSERT and UPDATE
Дата
Msg-id CACPNZCt7aVDBkSmjg_wgMTX17amJpc-pS7OwGEz_kYRQ6mZx3w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Delay locking partitions during INSERT and UPDATE  (David Rowley <david.rowley@2ndquadrant.com>)
Ответы Re: Delay locking partitions during INSERT and UPDATE  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-hackers
Дерево обсуждения 
On Wed, Jan 23, 2019 at 7:56 PM David Rowley
<david.rowley@2ndquadrant.com> wrote:
> On Thu, 24 Jan 2019 at 13:38, John Naylor <john.naylor@2ndquadrant.com> wrote:
> > Hmm, now instead of an 85x speedup over master in the 10k partition
> > case, I only get 20x. Anyone else see this?
>
> What's it like with fsync off?

No change. Just in case, I tried git bisect and also recreated the
cluster, but never got the same performance as my first test, so not
sure what happened.
--
John Naylor                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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

Предыдущее
От: John Naylor
Дата:
Сообщение: Re: WIP: Avoid creation of the free space map for small tables
Следующее
От: Jeremy Finzel
Дата:
Сообщение: Implicit timezone conversion replicating from timestamp to timestamptz?