Arvind Singh wrote: > > ok, > > thanks i will look into walbuffers > > asynchronous_commit=off is a doubt for responsive environment (pg manual). > for ex. > > would it help if, > > a game player , has to perform next move on basis of his/her previous move > plus other players move. > all is sent to table and for each player a particular set is retrieved with a > minimalistic data portfolio
The database will see all data as committed, regardless of commit being synchronous or asynchronous (note the setting is actually called synchronous_commit). There is only a doubt about it being committed after a database crash. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
