Le 25/03/2010 08:49, Yan Cheng CHEOK a écrit : > I was wondering whether setting synchronous_commit = off will have the following side effect. > > (1) Process A issues UPDATE command on row x, from false to true. > (2) After that, Process B READ from row x. > > Is it possible that when Process B start to read row x, the "true" value is not being "flushed" to the table. Hence, process B will read the row x as false? > No, it's not possible. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general