| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2006-02-24 18:50:49 | Re: BUG #2266: SQL_ATTR_CONNECTION_DEAD always returns SQL_CD_TRUE |
| Previous Message | herianto | 2006-02-24 11:48:13 | BUG #2279: invalid page header in block 95 of newtrd |