Nico Sabbi <nicola.sabbi@xxxxxxxx> wrote: > Can you give any hint on the configuration and on the underlying > hardware? Well, this particular web site has millions of hits per day (running up to about 20 queries per hit) from thousands of concurrent web users, while accepting logical replication from thousands of OLTP users via logical replication, so you probably don't need equivalent hardware. If I recall correctly it is running 32 cores with 512GB RAM running two PostgreSQL clusters, each multiple TB, and each having a RAID 5 array of 40 drives, plus separate controllers and RAID for OS and WAL. For server configuration, see these Wiki pages for the general tuning techniques used: https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server https://wiki.postgresql.org/wiki/Number_Of_Database_Connections The best course to solve your problem would probably be to review those and see what might apply, and if you still have a problem pick a specific slow-running query and use the process described here: https://wiki.postgresql.org/wiki/SlowQueryQuestions -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
