Re: inefficient use of relation extension?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: inefficient use of relation extension?
Date: 2009-10-15 23:58:20
Message-ID: 16309.1255651100@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:
> 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jesse Morris 2009-10-16 00:08:36 Re: BUG #5065: pg_ctl start fails as administrator, with "could not locate matching postgres executable"
Previous Message Alvaro Herrera 2009-10-15 23:53:34 Re: inefficient use of relation extension?