Re: the big picture for index-only scans - Mailing list pgsql-hackers

From Gokulakannan Somasundaram
Subject Re: the big picture for index-only scans
Date
Msg-id CAHMh4-ZeSXcFFeseFO9nAeL_25CjAUZnfvtoR7-0QUCBZ4iL-g@mail.gmail.com
Whole thread Raw
In response to Re: the big picture for index-only scans  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: the big picture for index-only scans
List pgsql-hackers

Well, that would certainly be alarming if true, but I don't think it
is.  As far as I can see, the overhead of making the visibility map
crash-safe is just (1) a very small percentage increase in the work
being done by VACUUM and (2) a slight possibility of extra work done
by a foreground process if the visibility map bit changes at almost
exactly the same time the process was about to insert, update, or
delete a tuple.

Let's forget the overhead posed by vacuum. Can you please point me to the design which talks in detail of the second overhead?

Thanks.

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: New copyright program
Next
From: Gokulakannan Somasundaram
Date:
Subject: Re: the big picture for index-only scans