[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

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

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 <i

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

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_connections? Thanks, FattahRozzaq -- Sent via pgsql-performance mailing list