Skip site navigation (1) Skip section navigation (2)

Re: BUG #2257: Can' stop server while autovacuum is running

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Evgeny Gridasov <eugrid(at)fpm(dot)kubsu(dot)ru>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2257: Can' stop server while autovacuum is running
Date: 2006-02-24 12:29:29
Message-ID: 200602241229.k1OCTTJ27000@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Tom Lane wrote:
> "Evgeny Gridasov" <eugrid(at)fpm(dot)kubsu(dot)ru> writes:
> > autovacuum process (when active) did not respond to kill (TERM). Only kill
> > -9 helped to stop autovacuum process.
> 
> autovacuum does respond to shutdown requests, but in poking at this I
> found that btree index vacuuming may fail to notice a pending interrupt
> for long periods, if you've got large indexes.  I've committed a fix
> for that.

Good catch.  I have heard index creation doesn't cancel easily, but
never investigated.

-- 
  Bruce Momjian   http://candle.pha.pa.us
  SRA OSS, Inc.   http://www.sraoss.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2006-02-24 18:50:49
Subject: Re: BUG #2266: SQL_ATTR_CONNECTION_DEAD always returns SQL_CD_TRUE
Previous:From: heriantoDate: 2006-02-24 11:48:13
Subject: BUG #2279: invalid page header in block 95 of newtrd

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group