Re: [PERFORM] Handling small inserts from many connections.

Hi team,

I'm trying to configure postgres and pgbouncer to handle many inserts from many connections.

Here's some details about what i want to achieve :

  We have more than 3000 client connections, and my server program forks backend process for each client connections.

  If backend processes send a request to its connected client, the client send some text data(about 3000 bytes) to the backend process and wait for

  next request.

  The backend process execute insert text data using PQexec from libpq lbirary, if PQexec is done, backend process send request to

  client again.

  All the inserts using one, same table.

The problem is, clients wait too long due to insert process is too slow.

It seems to working fine at first, but getting slows down after couple of hours,

each insert query takes 3000+ ms and keep growing.