Re: Proposal for CSN based snapshots

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Jeff Davis <pgsql(at)j-davis(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Greg Stark <stark(at)mit(dot)edu>, Andres Freund <andres(at)2ndquadrant(dot)com>, Rajeev rastogi <rajeev(dot)rastogi(at)huawei(dot)com>, Markus Wanner <markus(at)bluegap(dot)ch>, Ants Aasma <ants(at)cybertec(dot)at>, Bruce Momjian <bruce(at)momjian(dot)us>, obartunov <obartunov(at)postgrespro(dot)ru>, Teodor Sigaev <teodor(at)postgrespro(dot)ru>
Subject: Re: Proposal for CSN based snapshots
Date: 2016-08-10 16:24:22
Message-ID: 75c0ea70-6292-6b24-ac8f-cea21134f8d8@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 08/10/2016 09:04 AM, Stephen Frost wrote:
> * Joshua D. Drake (jd(at)commandprompt(dot)com) wrote:
>> +1 for Robert here, removing async commit is a non-starter. It is
>> PostgreSQL performance 101 that you disable synchronous commit
>> unless you have a specific data/business requirement that needs it.
>> Specifically because of how much faster Pg is with async commit.
>
> I agree that we don't want to get rid of async commit, but, for the
> archive, I wouldn't recommend using it unless you specifically understand
> and accept that trade-off, so I wouldn't lump it into a "PostgreSQL
> performance 101" group- that's increasing work_mem, shared_buffers, WAL
> size, etc. Accepting that you're going to lose *committed* transactions
> on a crash requires careful thought and consideration of what you're
> going to do when that happens, not the other way around.

Yes Stephen, you are correct which is why I said, "unless you have a
specific data/business requirement that needs it".

Thanks!

jD

>
> Thanks!
>
> Stephen
>

--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
Unless otherwise stated, opinions are my own.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Marko Tiikkaja 2016-08-10 16:27:12 Assertion failure in REL9_5_STABLE
Previous Message Vladimir Sitnikov 2016-08-10 16:18:38 Re: Slowness of extended protocol