From: Kevin Grittner <kgrittn@ymail.com>
To: Nico Sabbi <nicola.sabbi@poste.it>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Configuration tips for very large database
Date: Thu, 12 Feb 2015 22:55:20 +0000 (UTC)
Message-ID: <785380407.2469064.1423781720365.JavaMail.yahoo@mail.yahoo.com> (raw)
In-Reply-To: <54DD2DAD.3090503@poste.it>
References: <54DD2DAD.3090503@poste.it>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Nico Sabbi <nicola.sabbi@poste.it> 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_Serverhttps://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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: kgrittn@ymail.com, nicola.sabbi@poste.it
Subject: Re: Configuration tips for very large database
In-Reply-To: <785380407.2469064.1423781720365.JavaMail.yahoo@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox