Re: Auto-vacuum is not running in 9.1.12

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Prakash Itnal <prakash074(at)gmail(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, rasna(dot)t(at)nokia(dot)com, sandhya(dot)k_s(at)nokia(dot)com
Subject: Re: Auto-vacuum is not running in 9.1.12
Date: 2015-06-20 16:31:19
Message-ID: 45153.1434817879@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Prakash Itnal <prakash074(at)gmail(dot)com> writes:
> Sorry for the late response. The current patch only fixes the scenario-1
> listed below. It will not address the scenario-2. Also we need a fix in
> unix_latch.c where the remaining sleep time is evaluated, if latch is woken
> by other events (or result=0). Here to it is possible the latch might go in
> long sleep if time shifts to past time.

Forcing WL_TIMEOUT if the clock goes backwards seems like quite a bad
idea to me. That seems like a great way to make a bad situation worse,
ie it induces failures where there were none before.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2015-06-20 16:45:30 Re: Extension support for postgres_fdw
Previous Message Heikki Linnakangas 2015-06-20 16:23:07 Re: pg_stat_*_columns?