Re: Delay locking partitions during INSERT and UPDATE

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Delay locking partitions during INSERT and UPDATE
Дата
Msg-id CAKJS1f8fzAO+94VNP8mmvGiwzz2zUqHUJ-Xar+pTnEEbm1W+Hw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Delay locking partitions during INSERT and UPDATE  (John Naylor <john.naylor@2ndquadrant.com>)
Ответы Re: Delay locking partitions during INSERT and UPDATE  (John Naylor <john.naylor@2ndquadrant.com>)
Список pgsql-hackers
On Thu, 24 Jan 2019 at 13:38, John Naylor <john.naylor@2ndquadrant.com> wrote:
>
> On Tue, Jan 22, 2019 at 4:31 PM David Rowley
> <david.rowley@2ndquadrant.com> wrote:
> > Thanks. I've attached a rebased version.
>
> 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?

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


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

Предыдущее
От: "Bossart, Nathan"
Дата:
Сообщение: Re: A few new options for vacuumdb
Следующее
От: Amit Langote
Дата:
Сообщение: Re: inherited primary key misbehavior