Tom Lane wrote:
> "Evgeny Gridasov" <[EMAIL PROTECTED]> 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. +

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Reply via email to