[PERFORM] PostgreSQL limitation

Hi all, 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? How much the limit of max_files_per_process that PostgreSQL can take? Regards, Fattah -- -- Sent via

Re: [PERFORM] shared-buffers set to 24GB but the RAM only use 4-5 GB average

be fully use by PostgreSQL? I will test PostgreSQL with pg_bouncer in an identical logical (OS, softwares, etc) condition and physical resource condition. Respect, FattahRozzaq

Re: [PERFORM] shared-buffers set to 24GB but the RAM only use 4-5 GB average

fluctuating even with the exact same query. Any idea on how I should configure postgres to effectively utilize the hardware and reduce the response time to be quicker? *(RAM=128GB, CPU=24cores, RAID-1+0:SSD) Thanks, FattahRozzaq *looking for answer* On 06/10/2015, Igor Neyman wrote

[PERFORM] shared-buffers set to 24GB but the RAM only use 4-5 GB average

m (3GB size if pg_dump'ed) - message (17GB if pg_dump'ed) The backend application is a messaging server, in average there will be 40-180 connections to the postgres Server. The traffic is quite almost-heavy. How to make postgres-xl effectively utilizes the resource of RAM for max_c

[PERFORM] PostgreSQL Tuning for Messaging/Messenger/Chatting Application

recommended configuration (postgresql.conf ?) for my requirement above? Big thanks in advance, FattahRozzaq -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance