Re: index only scan question

From: Daniel Westermann <daniel(dot)westermann(at)dbi-services(dot)com>
To: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: index only scan question
Date: 2018-11-09 13:48:49
Message-ID: AM4PR0901MB134617B52A52A8E308E16AF8D2C60@AM4PR0901MB1346.eurprd09.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


>Am 09.11.2018 um 13:58 schrieb Daniel Westermann:
>> Is that because of some sort of caching?

>no, but vacuum updated the visibility map in the meantime.

No, it do not, double checked that with:
select pg_visibility_map('t1'::regclass, 0);

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Westermann 2018-11-09 14:00:38 Re: index only scan question
Previous Message Andreas Kretschmer 2018-11-09 13:38:19 Re: index only scan question