Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UwuaT-0007Hj-Un for pgsql-performance@arkaria.postgresql.org; Wed, 10 Jul 2013 13:37:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1UwuaT-0000Ut-7h for pgsql-performance@arkaria.postgresql.org; Wed, 10 Jul 2013 13:37:41 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UwuaR-0000Ui-1P for pgsql-performance@postgresql.org; Wed, 10 Jul 2013 13:37:39 +0000 Received: from nm13-vm0.bullet.mail.bf1.yahoo.com ([98.139.213.79]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UwuaN-0008O7-8z for pgsql-performance@postgresql.org; Wed, 10 Jul 2013 13:37:38 +0000 Received: from [66.196.81.170] by nm13.bullet.mail.bf1.yahoo.com with NNFMP; 10 Jul 2013 13:37:34 -0000 Received: from [98.139.212.215] by tm16.bullet.mail.bf1.yahoo.com with NNFMP; 10 Jul 2013 13:37:34 -0000 Received: from [127.0.0.1] by omp1024.mail.bf1.yahoo.com with NNFMP; 10 Jul 2013 13:37:34 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 158535.88805.bm@omp1024.mail.bf1.yahoo.com Received: (qmail 37761 invoked by uid 60001); 10 Jul 2013 13:37:33 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1373463453; bh=r2TfJgagZ1SXMgKoZkU+ekBnDT4WzQeQcM41hfWlGhg=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=rKPrXA0E+Mwc+YmKHHo496Om4zk3/8m6FqrjR+04YJIcB8fJNy5TIVUV7R4g3EJNwG2cICaDGvTygTBW5ouFTatbNRQQJYou4/ITGKzGRRNG+pftjFtzbWlbGogxOc8Z1smc+uw/+b7c6FVMsLQ7TP1dodwEt4k6sEofaBTLf4w= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=6rpByTCbhqH3x09MBYr/lseQmQ/2d39VkkjSA1TjXDtjDBt6Y4HBNdH6ebEYw7mKr24lLJDTtt7L8bo4qXBImB+BQb17/ejMv12dwyWvrAGQqSb48FNoAzXCNaZdj2AgeE3nohHjVyi0HhvlUvsmGS+4gUVOdNByyDJEy+FyspU= ; X-YMail-OSG: Bsx_41UVM1kQvZ2t7NEJuj3S0tRJPj77KxVDLq09.NmpDcR zNa0fVIerIz1jD8uZPIPcG6ajcfW18Cx7gpuHoJwayknV.o9oz8g5OqjLgvq 1rnJOt5Y1U.ainLoHuozdAmWQKfF8JliHqL_yBUV0g3FhlXsSVZq9YuV.KY_ V4LRp3xhzklVkQixy3hUayElhR2Q5S.agfelgHUn3byLooGF_7G7FO106bq6 z0FlmbTnLC2RAfLPcHOzMxKeH3S72XSZzDYbsQDHM9eEfa97Olt38.ZwzrBo NdsTGrOKVRYB1GFz_HYCqg1FU0Z.kN83lpH4IkhZUrtRywzeSjGX.6hYeZI3 dmfKbThsBXKDQmlUT_LDlSrslZWdbPajtyyruqpeqnlXEBgQ4q4m3pCs1OmE wTt0VI_7FFC9rNeHEYuqQyIBoOf1vqd0ubORMkY8iSlKQLEX4xA7aFomII8k s2Qp_Rc3GKw33t20pccRviiFDDBCaDcny11bNVEbyZXyQa1vuusbSDamAaho mbYvuycxNdKm4goCtR_HY4w8vx_Sf2EWJdSEjrzI93DG9OQKUVofqUkpdhXa XpHFHZFmwxUMnwiWxpUYULz669hFVS8UvIl0CnVOY4J_aRR55P35c1wESDAq S26KZLi5BhSJWww-- Received: from [76.255.18.237] by web162904.mail.bf1.yahoo.com via HTTP; Wed, 10 Jul 2013 06:37:33 PDT X-Rocket-MIMEInfo: 002.001, SmVpc29uIEJlZG95YSA8amVpc29uYkBhdWRpZmFybWEuY29tLmNvPiB3cm90ZToKCj4gUmFtOiAxMjhHQgoKPiBtYXhfY29ubmVjdGlvbnMgPSA5MDAKCj4gdGVtcF9idWZmZXJzID0gMTI4TUIKCkJlc2lkZXMgdGhlIGNvbmNlcm5zIGFscmVhZHkgZXhwcmVzc2VkIGFib3V0IHdvcmtfbWVtLCB0ZW1wX2J1ZmZlcnMKY291bGQgYmUgYSBiaWcgcHJvYmxlbS7CoCBJZiBhIGNvbm5lY3Rpb24gdXNlcyB0ZW1wIHRhYmxlcyBpdAphY3F1aXJlcyB1cCB0byAxMjhNQiwgKmFuZCBob2xkcyBvbiBpdCByZXNlcnZlZCABMAEBAQE- X-Mailer: YahooMailWebService/0.8.148.557 References: <51DAE734.3090706@audifarma.com.co> <51DAEB63.3050607@dunslane.net> <51DAF079.1080502@audifarma.com.co> Message-ID: <1373463453.36614.YahooMailNeo@web162904.mail.bf1.yahoo.com> Date: Wed, 10 Jul 2013 06:37:33 -0700 (PDT) From: Kevin Grittner Reply-To: Kevin Grittner Subject: Re: Process in state BIND, authentication, PARSE To: Jeison Bedoya , "pgsql-performance@postgresql.org" In-Reply-To: <51DAF079.1080502@audifarma.com.co> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: 0.7 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org Jeison Bedoya wrote: > Ram: 128GB > max_connections =3D 900 > temp_buffers =3D 128MB Besides the concerns already expressed about work_mem, temp_buffers could be a big problem.=A0 If a connection uses temp tables it acquires up to 128MB, *and holds on it reserved for caching temp tables for that connection for as long as the connection lasts*.=20 So, for 900 connections, that could be 112.5 GB.=A0 I would expect to see performance decrease and eventually completely tank as more connections reserved memory for this purpose. -- Kevin Grittner EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company --=20 Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance