Re: PostgreSQL limitation

On Mon, Nov 2, 2015 at 7:52 PM, FattahRozzaq <ssoorruu(at)gmail(dot)com> wrote:
> If I install the PostgreSQL on Linux (Debian),
> How much the limit of max_connections that PostgreSQL can take?
> How much the limit of max_prepared_transactions that PostgreSQL can take?

Per definition, those parameters have a max value of 2^23-1. For a
Postgres instance, a couple of hundred connections is already a lot,
and you'd want not really much more than the maximum number of
connections for max_prepared_transactions.

> How much the limit of max_files_per_process that PostgreSQL can take?

And this one has a maximum limit of 2^31-1. This can be helpful on
some platforms where kernel allows a process to open more files than
it can, like FreeBSD.
--
Michael