From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: crash-safe visibility map, take three |
Date: | 2010-11-30 17:12:35 |
Message-ID: | AANLkTikAoV4DzuwSts4HZkSi65hsEGs5tX7WBYmdpq7z@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, Nov 30, 2010 at 12:10 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Robert Haas <robertmhaas(at)gmail(dot)com> writes:
>> We're not going to double the cost of VACUUM to get index-only scans.
>> And that's exactly what will happen if you do full-page writes of
>> every heap page to set a single bit.
>
> It's ridiculous to claim that that "doubles the cost of VACUUM". In the
> worst case, it will add 25% to the cost of setting an all-visible bit on
> a page where there is no other work to do. (You already are writing out
> the heap page and the VM page,
True.
> plus a WAL image of the heap page, so a
False. That is exactly what we are NOT doing now and what we must
find a way to avoid doing.
> WAL image of the VM page adds 25%. But only if you did not set any
> other bits on the same VM page, which is probably not a real common
> case.) Given that VACUUM has a lot of other cleanup besides visibility
> bit setting, I'm not convinced that this would even be noticeable.
>
> I think the burden is on people who are proposing complicated mechanisms
> to show that there's actually a strong need for them.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-11-30 17:22:02 | Re: crash-safe visibility map, take three |
Previous Message | Tom Lane | 2010-11-30 17:10:49 | Re: crash-safe visibility map, take three |