Home > mailing lists

WAL being written during SELECT * query - Mailing list pgsql-general

From	Tom DalPozzo
Subject	WAL being written during SELECT * query
Date	April 4, 2017 21:46:59
Msg-id	CAK77FCSmrzOA7He_g8Gv48Z4krfDW-H5rqe4Z4ApTKk5GFt_6g@mail.gmail.com Whole thread Raw
Responses	Re: WAL being written during SELECT * query (Scott Marlowe <scott.marlowe@gmail.com>)
List	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

From: "Armand Pirvu (home)"
Date: 04 April 2017, 21:41:42
Subject: store key name pattern search

From: Oleg Bartunov
Date: 04 April 2017, 21:50:46
Subject: Re: store key name pattern search