Re: READ COMMITTED vs. index-only scans

On Wed, Jan 17, 2018 at 9:34 PM, Jacek Kołodziej wrote: > Hi Tom, > > On Wed, Jan 17, 2018 at 7:56 PM, Tom Lane wrote: > >> =?UTF-8?Q?Jacek_Ko=C5=82odziej?= writes: >> > Here's what happening to me: the "A" query occasionally (in my case: on >>

Re: READ COMMITTED vs. index-only scans

s, tom lane > I'm using 9.6.5; I'm not administrating it so it might take some time before updating but once it's done, I'll get back with whether that fixed the situation. In the meantime, when trying to reproduce it locally, I'll use both 9.6.5 and 9.6.6 to see whether it makes any difference. Thank you very much for the suggestions. -- Kind regards, Jacek Kołodziej http://kolodziejj.info

Re: READ COMMITTED vs. index-only scans

17.01.2018 3:30 PM "Melvin Davidson" napisał(a): On Wed, Jan 17, 2018 at 8:08 AM, Jacek Kołodziej wrote: > Hello everyone, > > this is my first post here and I'm starting with asking a question about > data consistency between two consecutive SELECTs using Postg

READ COMMITTED vs. index-only scans

ps://www.postgresql.org/docs/9.6/static/indexes-index-only-scans.html [1] https://www.postgresql.org/docs/9.6/static/storage-vm.html [2] https://wiki.postgresql.org/wiki/Index-only_scans -- Kind regards, Jacek Kołodziej http://kolodziejj.info