From shimeee@yahoo.com Wed Sep 17 17:10:31 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D05D46501A7 for ; Wed, 17 Sep 2008 14:10:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 78882-06-2 for ; Wed, 17 Sep 2008 14:10:27 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from web56101.mail.re3.yahoo.com (web56101.mail.re3.yahoo.com [216.252.110.195]) by postgresql.org (Postfix) with SMTP id 8950D650094 for ; Wed, 17 Sep 2008 14:01:22 -0300 (ADT) Received: (qmail 28389 invoked by uid 60001); 17 Sep 2008 17:01:10 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=Cxc7RRbMQPLcaifvhbNIChEy4FivvVXBlkVf5ocgcvgmOsN2EhRAsNHbxgTjW59aheUCrPjQm130I6FtZsA+L+4D+PMK2TbVVK+maWQAGZDEgJsnNA+339Z8GBMS8Xtk4kJ1lm702YTC3j91c6g54B28hKhLDrOU10+kxvy43kc=; X-YMail-OSG: 0c6X33EVM1m6aQnn5m1BnMy.q09yBk2f8E8DVwInSSRT_L4Y_HROVWPDHhM.VtW20sIjdrI3ck1EuD0S6ghUqiG05F967kZPHua0sYOm7iELzXBE2tvy4H6yWZDGyo9ebFLNBhyNAsgnSPzxhJsxcYrEJnbB5g-- Received: from [12.197.170.2] by web56101.mail.re3.yahoo.com via HTTP; Wed, 17 Sep 2008 10:01:10 PDT X-Mailer: YahooMailRC/1096.28 YahooMailWebService/0.7.218.2 Date: Wed, 17 Sep 2008 10:01:10 -0700 (PDT) From: M C Subject: Recommended number of connections To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-121657462-1221670870=:28250" Message-ID: <539764.28250.qm@web56101.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200809/176 X-Sequence-Number: 30269 --0-121657462-1221670870=:28250 Content-Type: text/plain; charset=us-ascii What are the "maximum" amount of "connections" allowed to "postgres"? and what would be a resonable amount of connection/processes to see based on user connections? --0-121657462-1221670870=:28250 Content-Type: text/html; charset=us-ascii
What are the "maximum" amount of "connections" allowed to "postgres"? and what would be a resonable amount of connection/processes to see based on user connections?

--0-121657462-1221670870=:28250-- From HTomeh@facorelogic.com Wed Sep 17 19:33:24 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1E74D6501F7 for ; Wed, 17 Sep 2008 16:33:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 04032-04-3 for ; Wed, 17 Sep 2008 16:33:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outbound-smtp.firstam.com (outbound-smtp6.firstam.com [69.87.54.11]) by postgresql.org (Postfix) with ESMTP id BE551650078 for ; Wed, 17 Sep 2008 14:31:57 -0300 (ADT) Received: from mailmarshall.firstam.com (HELO pisgsna01smmx01.ana.firstamdata.com) ([172.17.88.35]) by outbound-smtp.firstam.com with ESMTP; 17 Sep 2008 10:31:43 -0700 Received: from PISGSNA01SXCH22.ana.firstamdata.com (Not Verified[172.17.88.79]) by pisgsna01smmx01.ana.firstamdata.com with MailMarshal (v6, 4, 0, 4772) id ; Wed, 17 Sep 2008 10:31:43 -0700 Received: from CITGSNA01SXCH02.ana.firstamdata.com ([172.17.88.30]) by PISGSNA01SXCH22.ana.firstamdata.com with Microsoft SMTPSVC(6.0.3790.3959); Wed, 17 Sep 2008 10:31:43 -0700 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C918EB.228AB004" Subject: Re: Recommended number of connections Date: Wed, 17 Sep 2008 10:30:53 -0700 Message-ID: In-Reply-To: <539764.28250.qm@web56101.mail.re3.yahoo.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] Recommended number of connections Thread-Index: AckY6Pm5c9CyQIKERdST8ZPdbXCEmQAADz3Q References: <539764.28250.qm@web56101.mail.re3.yahoo.com> From: "Tomeh, Husam" To: "M C" , X-OriginalArrivalTime: 17 Sep 2008 17:31:43.0903 (UTC) FILETIME=[40B932F0:01C918EB] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200809/178 X-Sequence-Number: 30271 This is a multi-part message in MIME format. ------_=_NextPart_001_01C918EB.228AB004 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable The maximum number of Postgres connections you can have may be controlled by adjusting the max_connections PG parameter based on your anticipated connections needs and requirements. =20 =20 Make sure that your Kernel's related parameters are also configured properly to accommodate your max_connections settings (e.g, in Linux, SEM* kernel's parameters) when increasing the max_connections parameter. =20 http://www.postgresql.org/docs/8.2/static/runtime-config-connection.html =20 http://www.postgresql.org/docs/8.2/static/kernel-resources.html#SYSVIPC =20 =20 Regards, =20 Husam=20 ________________________________ From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of M C Sent: Wednesday, September 17, 2008 10:01 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] Recommended number of connections =20 What are the "maximum" amount of "connections" allowed to "postgres"? and what would be a resonable amount of connection/processes to see based on user connections? =20 ********************************************************************** This message contains confidential information intended only for the use = of the addressee(s) named above and may contain information that is legal= ly privileged. If you are not the addressee, or the person responsible f= or delivering it to the addressee, you are hereby notified that reading, = disseminating, distributing or copying this message is strictly prohibite= d. If you have received this message by mistake, please immediately noti= fy us by replying to the message and delete the original message immediat= ely thereafter. Thank you. =0D =20 FADLD Tag ********************************************************************** ------_=_NextPart_001_01C918EB.228AB004 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

The maximum = number of Postgres connections you can have may be controlled by adjusting the max_connections PG parameter based on your anticipated connections needs = and requirements.  

 <= /o:p>

Make sure th= at your Kernel’s related parameters are also configured properly to accommo= date your max_connections settings (e.g, in Linux, SEM* kernel’s parameters) = when increasing the max_connections parameter.

 <= /o:p>

http://www.postgresql.org= /docs/8.2/static/runtime-config-connection.html

http://www.postgresql.org= /docs/8.2/static/kernel-resources.html#SYSVIPC

 <= /o:p>

Regards,

  =     Husam <= /span>


From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org= ] On Behalf Of M C
Sent: Wednesday, September= =2017, 2008 10:01 AM
To: pgsql-admin@postgresql= .org
Subject: [ADMIN] Recommend= ed number of connections

 

What are the "maximum" amount of "connections" allowed to "postgres"? and what would b= e a resonable amount of connection/processes to see based on user connections= ?

 

**********************************************************************=
This=20 message contains confidential information intended only for the use of th= e=20 addressee(s) named above and may contain information that is legally=20 privileged.  If you are not the addressee, or the person responsible= =20for=20 delivering it to the addressee, you are hereby notified that reading,=20 disseminating, distributing or copying this message is strictly=20 prohibited.  If you have received this message by mistake, please=20 immediately notify us by replying to the message and delete the original = message=20 immediately thereafter.

Thank you.

          &nbs= p;            = ;            =             &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =              = FADLD=20 Tag
***********************************************************= ***********

------_=_NextPart_001_01C918EB.228AB004-- From scott.marlowe@gmail.com Wed Sep 17 19:59:34 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E2D2C64FD0A for ; Wed, 17 Sep 2008 16:59:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 10855-01 for ; Wed, 17 Sep 2008 16:59:22 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.233]) by postgresql.org (Postfix) with ESMTP id 0D43564FCD7 for ; Wed, 17 Sep 2008 14:39:48 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id b25so4288645rvf.43 for ; Wed, 17 Sep 2008 10:39:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=P/9iOm8IUgYsumrhaXkauf6ERtfzq7DvFh7i3TP5Abo=; b=sao8MeCOmdXAA15UWqBOxU8zLFpYWWF4vlKNEQDulp5gDRWpPuotrU3q2yMzGToSlN PpPhy8gMfszpdJ2BBjMs0cX5jXZ3EeToVH0P8zDUPNAz1YTKZY8qQte1re6ax+yR2DMr m51yeH/x9yNiG4orFX0CgY84oCHltMAKgEzls= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=A0hCQ0KNI2Vr5dWmXYkGhyOf+51ftD1tCKl7T1tsaVGihWkgjRlBkMfcEmgF7Nb1Eq 79bgETSlCJVsIVAkwOkicZlPnxVguB7o2EV65wtUdR+GPCsfOFmv9+hf7hw6cmjbGGuG ciyTQSwQFYXi9NxGhlilzlQ/5QKze8rEtv1A4= Received: by 10.140.132.8 with SMTP id f8mr6708857rvd.206.1221673177630; Wed, 17 Sep 2008 10:39:37 -0700 (PDT) Received: by 10.141.74.11 with HTTP; Wed, 17 Sep 2008 10:39:37 -0700 (PDT) Message-ID: Date: Wed, 17 Sep 2008 11:39:37 -0600 From: "Scott Marlowe" To: "M C" Subject: Re: Recommended number of connections Cc: pgsql-admin@postgresql.org In-Reply-To: <539764.28250.qm@web56101.mail.re3.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <539764.28250.qm@web56101.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/182 X-Sequence-Number: 30275 On Wed, Sep 17, 2008 at 11:01 AM, M C wrote: > What are the "maximum" amount of "connections" allowed to "postgres"? and > what would be a resonable amount of connection/processes to see based on > user connections? That really depends on what you're doing with it. If each connection is doing a simple transaction on a small indexed set, then you can probably have hundreds of connections open on an even modest machine. OTOH, if you're running reports across hundreds of megs with a large work_mem setting then you might be best with only a few dozen or so connections. So, what are ya doing and how many users are you supporting at once?