synchronous_commit and mvcc

Поиск
Список
Период
Сортировка
От Kelly Burkhart
Тема synchronous_commit and mvcc
Дата
Msg-id fa1e4ce70908121228q70b1361cn72cb5263ef0664d2@mail.gmail.com
обсуждение исходный текст
Ответы Re: synchronous_commit and mvcc
Re: synchronous_commit and mvcc
Список pgsql-general
Hello,

We have synchronous_commit=off in our postgresql.conf file.  Does this setting affect mvcc?  For instance if I have two connections from processes on different machines that do the following:

c1 begins transaction
c1 inserts rows into table
c1 commits transaction
c2 begins transaction
c2 queries table

At this point, is it possible that c2 is not able to see the rows from connection 1 that were inserted and committed prior to the c2 transaction starting?

Thanks,

-K

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

Предыдущее
От: Sam Mason
Дата:
Сообщение: Re: comparing NEW and OLD (any good this way?)
Следующее
От: Greg Stark
Дата:
Сообщение: Re: synchronous_commit and mvcc