Re: Synchronous commit not... synchronous?

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Synchronous commit not... synchronous?
Дата
Msg-id CAB7nPqSB7jKFTo-3poco3vZv66VUc_1Xs2k0wz3PkyCQNc1pVw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Synchronous commit not... synchronous?  (David Fetter <david@fetter.org>)
Ответы Re: Synchronous commit not... synchronous?  (David Fetter <david@fetter.org>)
Список pgsql-hackers
Дерево обсуждения


On Thu, Nov 1, 2012 at 1:03 PM, David Fetter <david@fetter.org> wrote:
On Wed, Oct 31, 2012 at 06:39:20PM -0700, Peter van Hardenberg wrote:
> This was rather surprising - my synchronous commit was... not
> cancelled.  Is this expected behaviour?

I believe it is.

Does the following do the right thing?

SET synchronous_commit='on';
BEGIN;
INSERT INTO data VALUES ('baz');
COMMIT;^c

Oh, and how did you get that cancel in?
He enforced a manual cancel from client with something like Ctrl+C to cancel query.
In this case you do not wait for the slave to confirm that the commit information has been flushed on its disk.
--
Michael Paquier
http://michael.otacoo.com

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

Предыдущее
От: Amit kapila
Дата:
Сообщение: Re: alter table tablename add column - breaks pl/pgsql function returns tablename
Следующее
От: David Fetter
Дата:
Сообщение: Re: Synchronous commit not... synchronous?