Re: autovacuum starvation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Jim Nasby <decibel(at)decibel(dot)org>, Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: autovacuum starvation
Date: 2007-05-08 05:29:23
Message-ID: 23200.1178602163@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> We could have the postmaster signal the launcher, but the signal cannot
> contain much useful info because the postmaster does generally not want
> to write in shared memory.

The postmaster already touches/writes in shared memory in pmsignal.c.
The trick here is that whatever it does should be sufficiently
constrained that arbitrarily-bad corruption of shared memory can't
crash or freeze the postmaster. If you can meet that restriction,
feel free to introduce some more signaling knowledge.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message ITAGAKI Takahiro 2007-05-08 08:19:33 Re: Allow use of stable functions with constraint exclusion
Previous Message Hiroshi Inoue 2007-05-08 04:02:45 Re: Re: [COMMITTERS] psqlodbc - psqlodbc: Put Autotools-generated files into subdirectory