On Mon, Aug 19, 2013 at 10:44 PM, Rural Hunter wrote:
> Hi,
>
> I'm on 9.2.4 with Ubuntu server. There are usually hundereds of
> connections doing the same insert with different data from different
> networks every minute, through pgbouncer in the same network of the
> database server. The databa
(@Jeff, sorry I sent this message only to you by mistake, sending to the
list now...)
On Tue, Aug 20, 2013 at 9:24 PM, Jeff Janes wrote:
> On Mon, Aug 19, 2013 at 10:30 PM, Rural Hunter
> wrote:
> > 于 2013/8/20 12:34, Jeff Janes 写道:
> >
>
> > > How long had they been hanging there? It makes a
Hi Jeff,
Thanks a lot for such a detailed guide!
于 2013/8/21 8:24, Jeff Janes 写道:
OK, that certainly does sound like network problems and not disk
contention. But what I don't see is why it would be listed as
"active" in pg_stat_activity. If it is blocked on a network
connection, I would
On Mon, Aug 19, 2013 at 10:30 PM, Rural Hunter
>
wrote:
> 于 2013/8/20 12:34, Jeff Janes 写道:
>
> > How long had they been hanging there? It makes a big difference whether
> > there are several hanging there at one moment, but a few milliseconds
later
> > there are several different ones, versus th
于 2013/8/20 12:34, Jeff Janes 写道:
On Monday, August 19, 2013, Rural Hunter wrote:
I think that this should generally not happen at the server
if you are using pgbouncer, as you should configure it so that
pgbouncer has a lower limit than postg
On Monday, August 19, 2013, Rural Hunter wrote:
> Hi,
>
> I'm on 9.2.4 with Ubuntu server. There are usually hundereds of
> connections doing the same insert with different data from different
> networks every minute, through pgbouncer in the same network of the
> database server. The database has
On Mon, Aug 19, 2013 at 7:45 PM, Rural Hunter wrote:
>> You mentioned the "incomplete message from client" error, so it might
>> somehow be a network problem that led to a hunging connection to pgbouncer,
>> that made pgbouncer kept a connection to postgres after transaction was
>> started.
>
> pg
于 2013/8/20 10:38, Sergey Konoplev 写道:
On Mon, Aug 19, 2013 at 6:44 PM, Rural Hunter wrote:
What do you mean by recycling pgbouncer?
I mean restarting pgbouncer.
Haven't you noticed what was in the state column of the
pg_state_activity view? In 9.2 the query column in this view shows the
las
On Mon, Aug 19, 2013 at 6:44 PM, Rural Hunter wrote:
> I'm on 9.2.4 with Ubuntu server. There are usually hundereds of connections
> doing the same insert with different data from different networks every
> minute, through pgbouncer in the same network of the database server. The
> database has be
Hi,
I'm on 9.2.4 with Ubuntu server. There are usually hundereds of
connections doing the same insert with different data from different
networks every minute, through pgbouncer in the same network of the
database server. The database has been running for about one year
without problem. Yeste
10 matches
Mail list logo
