From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
---|---|
To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
Cc: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Greg Stark <stark(at)mit(dot)edu>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Proposal: Log inability to lock pages during vacuum |
Date: | 2014-11-10 18:15:07 |
Message-ID: | 20141110181507.GG28007@alap3.anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 2014-11-10 14:28:30 -0300, Alvaro Herrera wrote:
> Jim Nasby wrote:
> > On 11/7/14, 8:21 PM, Robert Haas wrote:
> > >On Thu, Nov 6, 2014 at 8:03 PM, Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com> wrote:
> > >>The problem right now is there's no way to actually obtain evidence that
> > >>this is (or isn't) something to worry about, because we just silently skip
> > >>pages. If we had any kind of tracking on this we could stop guessing. :(
> > >
> > >I could see logging it, but I agree with Andres and Alvaro that the
> > >odds are strongly against there being any actual problem here.
> >
> > I'm fine with that. Any other objections? Andres?
If you feel that strong about the need for logging, go ahead.
> If what we want is to quantify the extent of the issue, would it be more
> convenient to save counters to pgstat? Vacuum already sends pgstat
> messages, so there's no additional traffic there.
I'm pretty strongly against that one in isolation. They'd need to be
stored somewhere and they'd need to be queryable somewhere with enough
context to make sense. To actually make sense of the numbers we'd also
need to report all the other datapoints of vacuum in some form. That's
quite a worthwile project imo - but *much* *much* more work than this.
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2014-11-10 18:24:58 | Re: REINDEX CONCURRENTLY 2.0 |
Previous Message | Andres Freund | 2014-11-10 18:05:46 | Re: Allow signal handlers to optionally use SA_SIGINFO information? |