Re: Index-only scan performance regression - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Index-only scan performance regression
Date
Msg-id 12927.1328051094@sss.pgh.pa.us
Whole thread Raw
In response to Re: Index-only scan performance regression  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: Index-only scan performance regression  (Dean Rasheed <dean.a.rasheed@gmail.com>)
List pgsql-hackers
Dean Rasheed <dean.a.rasheed@gmail.com> writes:
> The thing I'm unsure about is whether sending sinval
> messages when the visibility map is extended is a good idea.

Seems perfectly reasonable to me.  They'd occur so seldom as to be
more than repaid if we can scrape some cost out of the mainline paths.

The real objection to this probably is that if it only saves anything
for tables that don't have a VM yet, it's dubious whether it's worth
doing.  But if we can avoid wasted checks for VM extension as well,
then I think it's probably a no-brainer.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] pg_dump -s dumps data?!
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] pg_dump -s dumps data?!