Re: inefficient use of relation extension?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: inefficient use of relation extension?
Дата
Msg-id 16309.1255651100@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: inefficient use of relation extension?  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: inefficient use of relation extension?  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Hmm ... this is something that had not occured to me earlier.  There is
> a connection pool here (JDBCConnectionPool I'm told; hadn't heard about
> that one) and there are about 100 backends permanently, not all of which
> are always busy.  Perhaps what's going on here is that some of them are
> idle for long enough that the sinval queue gets full.

Hm, that's definitely possible, and 8.1 did not have very good code for
coping with sinval overrun.  But it's not clear to me why that would
affect the rel extension code path in particular.
        regards, tom lane


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: inefficient use of relation extension?
Следующее
От: Itagaki Takahiro
Дата:
Сообщение: Re: Trigger with WHEN clause (WIP)