On 3/13/2015 2:59 AM, Job wrote:
The application i use need lots of static DB connections
if lots is much over a 100 or so, I'd strongly advise using a connection
pooler like pgbouncer or whatever is built into your language framework
(for instance, Java frameworks like Tomcat have built in c
On 3/13/2015 6:51 AM, sameer malve ⎝⏠⏝⏠⎠ wrote:
Just use pgtune utility it will give an o/p of u r postgres.conf
depending on your machine hardware .
I find on newer large hardware, pg_tune makes some over-the-top choices.
--
john r pierce 37N 122W
somewh
On 03/13/2015 02:59 AM, Job wrote:
Hello,
i have just installed (on a Centos 6.5 x64 machine) Postgresql 9 latest stable
version.
The application i use need lots of static DB connections: in the 9 version, how
many connections can be declared in postgresql.conf?
I searched for a max number bu
Hello ,
Just use pgtune utility it will give an o/p of u r postgres.conf depending
on your machine hardware .
Regards,
Sameer
On Mar 13, 2015 5:45 PM, "Vick Khera" wrote:
>
> On Fri, Mar 13, 2015 at 5:59 AM, Job wrote:
>
>> The application i use need lots of static DB connections: in the 9
>>
On Fri, Mar 13, 2015 at 5:59 AM, Job wrote:
> The application i use need lots of static DB connections: in the 9
> version, how many connections can be declared in postgresql.conf?
> I searched for a max number but i noticed it is not specified.
>
It depends on how much shared memory you give to
Hello,
i have just installed (on a Centos 6.5 x64 machine) Postgresql 9 latest stable
version.
The application i use need lots of static DB connections: in the 9 version, how
many connections can be declared in postgresql.conf?
I searched for a max number but i noticed it is not specified.
Tha
Hello,
i have just installed (on a Centos 6.5 x64 machine) Postgresql 9 latest stable
version.
The application i use need lots of static DB connections: in the 9 version, how
many connections can be declared in postgresql.conf?
I searched for a max number but i noticed it is not specified.
Tha
John Gateley <[EMAIL PROTECTED]> writes:
> Hi, I'm using the Pg perl module to connect to Postgresql 8.1
> via localhost (127.0.0.1) from webscripts. I'm noticing a lot
> of TIME_WAIT socket connections:
> tcp0 0 127.0.0.1:39291 127.0.0.1:5432 TIME_WAIT
>
> tcp
Hi, I'm using the Pg perl module to connect to Postgresql 8.1
via localhost (127.0.0.1) from webscripts. I'm noticing a lot
of TIME_WAIT socket connections:
tcp0 0 127.0.0.1:39291 127.0.0.1:5432 TIME_WAIT
tcp0 0 127.0.0.1:60720 127.0.0.1:5432
