Big number of connections

From: Jarek <jarek(at)poczta(dot)srv(dot)pl>
To: pgsql-performance(at)postgresql(dot)org
Subject: Big number of connections
Date: 2016-03-31 19:08:06
Message-ID: 1459451286.26406.16.camel@sem-jarek-01.prv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Igor Neyman 2016-03-31 19:12:44 Re: Big number of connections
Previous Message ktm@rice.edu 2016-03-31 19:08:03 Re: Adding a ROLLUP switches to GroupAggregate unexpectedly