Re: Looking for software to 'enqueue' connections

On 8/15/2016 1:30 PM, Edmundo Robles wrote:
> I want find  a software to 'enqueue' the client connections to
> database, so if i reach the max limit the query must be holding in a
> queue   until one connection is released.
>

pgbouncer is the correct answer, you may need to play about with the
configuration a bit.   there's a few modes that might work, ideally,
write your apps to connect to postgres, do a transaction, and
disconnect, and limit the pool size so only so many connections can be
active at a time.    the other mode is to allow the clients to stay
connected to the pool, but have a limited number of actual database
connections that you allocate on a transaction basis.

> I have  many devices (100+) saving  their state to a database,  each
> minute,  but  the table is too large more than 13,000,000 of records
> and many indexes, so, insert  one record takes 3 or more minutes.

that sounds terrible.   single row inserts shouldn't *ever* take 3
minutes, if you have clients inserting a row a minute.   you may need
faster disk storage, you may need to improve postgres tuning.

'many indexes' ?  how many ?  too many indexes would definitely slow
inserts down.


--
john r pierce, recycling bits in santa cruz