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