Read consistency when using synchronous_commit=off

2019-01-15 Thread pshadangi
To improve commit performance we are planning to use "synchronous_commit=off", with this if multiple clients are reading the same data/row will they always get the latest updated data/row ? (clients are using committed read and we are not using clustered environment, we have just one instance of po

Re: Read consistency when using synchronous_commit=off

2019-01-15 Thread pshadangi
> After better thinking, I have to reply to myself since I m not entirely sure of my previous question. (I m digging into the docs, but i do not want to mislead you in the meanwhile) Yes, I was not able to get some statement regarding this in the docs, please let me know if you find something. Tha

Re: Read consistency when using synchronous_commit=off

2019-01-16 Thread pshadangi
Thanks Ravi for the clarification, we will go ahead with "synchronous_commit=off". On Wed, Jan 16, 2019 at 10:47 AM Ravi Krishna wrote: > Sorry I misunderstood. The term "read consistency" is generally used > either in the context of isolation level or in the context of slaves. > > We don't hav