On 08/15/2016 01:59 PM, Edmundo Robles wrote:
Please do not top post:
https://en.wikipedia.org/wiki/Posting_style
The preferred style is bottom or interleaved as it makes the thread
easier to follow
Adrian i have hosted in a rackspace a Debian 7 with 2G RAM.
I assume that would be one o
Adrian i have hosted in a rackspace a Debian 7 with 2G RAM.
John, the table have 8 constraints and 5 indexes.
Ilya thanks for the tip, i will search about OLTP.
On Mon, Aug 15, 2016 at 3:47 PM, Ilya Kazakevich <
ilya.kazakev...@jetbrains.com> wrote:
> Hello.
>
>
>
> From:
>
> http://www.pg
Hello.
From:
http://www.pgpool.net/
pgpool-II also has a limit on the maximum number of connections, but extra
connections will be queued instead of returning an error immediately.
But your configuration does not look optimal for me. Here are some things you
may try:
1) Get rid of
On 08/15/2016 01:30 PM, Edmundo Robles wrote:
Hi!
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.
I have many devices (100+) saving their state to a database, each
min
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
conf
