Home > mailing lists

Re: index only scan question - Mailing list pgsql-general

From	Daniel Westermann
Subject	Re: index only scan question
Date	November 9, 2018 16:48:49
Msg-id	AM4PR0901MB134617B52A52A8E308E16AF8D2C60@AM4PR0901MB1346.eurprd09.prod.outlook.com Whole thread Raw
In response to	Re: index only scan question (Andreas Kretschmer <andreas@a-kretschmer.de>)
List	pgsql-general

Tree view

>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);

pgsql-general by date:

From: Andreas Kretschmer
Date: 09 November 2018, 16:38:19
Subject: Re: index only scan question

From: Daniel Westermann
Date: 09 November 2018, 17:00:38
Subject: Re: index only scan question

Re: index only scan question - Mailing list pgsql-general

Previous

Next