WAL being written during SELECT * query

From: Tom DalPozzo <t(dot)dalpozzo(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: WAL being written during SELECT * query
Date: 2017-04-04 15:46:59
Message-ID: CAK77FCSmrzOA7He_g8Gv48Z4krfDW-H5rqe4Z4ApTKk5GFt_6g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2017-04-04 15:50:46 Re: store key name pattern search
Previous Message Armand Pirvu (home) 2017-04-04 15:41:42 store key name pattern search