Re: [ADMIN] postgresql in FreeBSD jails: proposal

Поиск
Список
Период
Сортировка
От Mischa Sandberg
Тема Re: [ADMIN] postgresql in FreeBSD jails: proposal
Дата
Msg-id 1200613953.478fea419c929@webmail.telus.net
обсуждение исходный текст
Ответ на Re: [ADMIN] postgresql in FreeBSD jails: proposal  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Quoting Tom Lane <tgl@sss.pgh.pa.us>:

> Mischa Sandberg <mischa_sandberg@telus.net> writes:
> > I'm going to skip the kill(1,0) test and depend on nattch only,
> > with a function that PGSharedMemoryIsInUse() can also use.
> > (For a healthy server, nattch is never less than 2, right?)
> 
> Oh, forgot to mention: healthy servers are not the point here.
> You should make the code keep its hands off any segment with
> nonzero nattch, because even one orphaned backend is enough
> to cause trouble.

Note taken. Worth putting a warning in the log, too?

Engineers think that equations approximate reality.
Physicists think that reality approximates the equations.
Mathematicians never make the connection.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [ADMIN] postgresql in FreeBSD jails: proposal
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Simple thing to make pg_autovacuum more useful