From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | Igor Neyman <ineyman(at)perceptron(dot)com>, Jarek <jarek(at)poczta(dot)srv(dot)pl>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Big number of connections |
Date: | 2016-03-31 19:51:23 |
Message-ID: | 56FD7FBB.4040403@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On 03/31/2016 03:12 PM, Igor Neyman wrote:
> -----Original Message-----
> From: pgsql-performance-owner(at)postgresql(dot)org [mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of Jarek
> Sent: Thursday, March 31, 2016 3:08 PM
> To: pgsql-performance(at)postgresql(dot)org
> Subject: [PERFORM] Big number of connections
>
> Hello!
>
> We are going to build system based on PostgreSQL database for huge number of individual users (few thousands). Each user will have his own account, for authorization we will use Kerberos (MIT or Windows).
> Most of users will have low activity, but for various reasons, connection should be open all the time.
> I'd like to know what potential problems and limitations we can expect with such deployment.
> During preliminary testing we have found that for each connection we need ~1MB RAM. Is there any way to decrease this ? Is there any risk, that such number of users will degrade performance ?
> I'll be happy to hear any remarks and suggestions related to design, administration and handling of such installation.
>
> best regards
> Jarek
>
> _______________________________________________________________________________
>
> Take a look at PgBouncer.
> It should solve your problems.
>
If they are going to keep the client connections open, they would need
to run pgbouncer in statement or transaction mode.
cheers
andrew
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2016-03-31 22:47:12 | Re: Big number of connections |
Previous Message | Igor Neyman | 2016-03-31 19:12:44 | Re: Big number of connections |