Tom Lane escribió: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > Tom Lane escribió: > >> BTW, if an autovac worker gets an elog(ERROR) on one table, does it die > >> or continue on with the next table? > > > It continues with the next table if interrupted (SIGINT), but the worker > > exits on any other error. > > Hmm, that seems backwards. What's the rationale?
I don't remember :-( We now use SIGTERM for shutdown, which closes the worker for good. It may well be that we need to change this so that the worker is shut down on specific error codes, instead of continuing on some other codes. Or it may need more thorough surgery. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(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
