On Tue, Apr 4, 2017 at 9:46 AM, Tom DalPozzo <t.dalpozzo@gmail.com> wrote: > Hi, > I have a very big table (10GB). > I noticed that many WAL segments are being written when elaborating read > only transactions like this: > select * from dati25600000000 where id >43000000 limit 1000000; > I don't understand why are there WAL writings during read only transactions. > Regards > Pupillo
I think this is the db setting hint bits, but I'm no expert in that area.
Hi,
I'm not able to reproduce the problem in a deterministic way. Sometimes it does sometimes not.
Anyway, examining with pg_xlogdum those WAL, I get many many records like these: