Re: inefficient use of relation extension? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: inefficient use of relation extension?
Date
Msg-id 16309.1255651100@sss.pgh.pa.us
Whole thread Raw
In response to Re: inefficient use of relation extension?  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: inefficient use of relation extension?
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: inefficient use of relation extension?
Next
From: Itagaki Takahiro
Date:
Subject: Re: Trigger with WHEN clause (WIP)