From: | daveg <daveg(at)sonic(dot)net> |
---|---|
To: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Greg Stark <gsstark(at)mit(dot)edu>, David Christensen <david(at)endpoint(dot)com>, Maxim Boguk <maxim(dot)boguk(at)gmail(dot)com>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] Re: PD_ALL_VISIBLE flag was incorrectly set happend during repeatable vacuum |
Date: | 2011-03-03 10:53:46 |
Message-ID: | 20110303105346.GD4053@sonic.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-hackers |
On Thu, Mar 03, 2011 at 10:16:29AM +0200, Heikki Linnakangas wrote:
> On 03.03.2011 09:12, daveg wrote:
> >Question: what would be the consequence of simply patching out the setting
> >of this flag? Assuming that the incorrect PD_ALL_VISIBLE flag is the only
> >problem (big assumption perhaps) then simply never setting it would at
> >least
> >avoid the possibility of returning wrong answers, presumably at some
> >performance cost. We possibly could live with that until we get a handle
> >on the real cause and fix.
>
> Yes. With that assumption.
>
> If you really want to do that, I would suggest the attached patch
> instead. This just disables the optimization in seqscans to trust it, so
> an incorrectly set flag won't affect correctness of query results, but
> the flag is still set as usual and you still get the warnings so that we
> can continue to debug the issue.
Thanks. I'll be applying this tomorrow and will send you some page images
to look at assuming it still does it.
I had a look at how this gets set and cleared and did not see anything obvious
so I'm pretty mystified. Also, we are seeing thousands of these daily for at
least a month on 4 large hosts and no-one has noticed any other issues,
which suprises me. Very strange.
-dg
--
David Gould daveg(at)sonic(dot)net 510 536 1443 510 282 0869
If simplicity worked, the world would be overrun with insects.
From | Date | Subject | |
---|---|---|---|
Next Message | Kenneth Marshall | 2011-03-03 14:10:54 | Re: long running commits |
Previous Message | Bernhard Rohrer | 2011-03-03 10:09:40 | Fwd: Re: PG_update to 9.0.4 in ubuntu lucid 64 |
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 2011-03-03 10:55:20 | Re: knngist - 0.8 |
Previous Message | Itagaki Takahiro | 2011-03-03 10:53:44 | aggregate version of first_value function? |