Re: vacuum as flags in PGPROC - Mailing list pgsql-patches

From Tom Lane
Subject Re: vacuum as flags in PGPROC
Date
Msg-id 3990.1193241317@sss.pgh.pa.us
Whole thread Raw
In response to Re: vacuum as flags in PGPROC  (Heikki Linnakangas <heikki@enterprisedb.com>)
Responses Re: vacuum as flags in PGPROC
List pgsql-patches
Heikki Linnakangas <heikki@enterprisedb.com> writes:
> Alvaro Herrera wrote:
>> I did it that way (i.e. added locking) and then realized that it
>> shouldn't really be a problem, because the only one who can be setting
>> vacuum flags is the process itself.  Other processes can only read the
>> flags.

> It would still be a problem if there was any other fields that were
> updated by other processes, adjacent to the vacuum flags. I don't think
> that's the case, however.

Well, that may not be the case today, but it still seems like an
assumption that will come back to bite us someday.  And can you imagine
trying to debug a misbehavior like that?  It's really not worth the risk,
given how seldom these flags will be changed.

            regards, tom lane

pgsql-patches by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: vacuum as flags in PGPROC
Next
From: Heikki Linnakangas
Date:
Subject: Re: vacuum as flags in PGPROC