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