Обсуждение: WAL being written during SELECT * query

Поиск
Список
Период
Сортировка

WAL being written during SELECT * query

От
Tom DalPozzo
Дата:
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




Re: WAL being written during SELECT * query

От
Scott Marlowe
Дата:
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.