On Mon, Nov 2, 2015 at 7:52 PM, FattahRozzaq <ssoorruu@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
