PostgreSQL Tuning for Messaging/Messenger/Chatting Application

From: FattahRozzaq <ssoorruu(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: PostgreSQL Tuning for Messaging/Messenger/Chatting Application
Date: 2015-09-02 12:16:23
Message-ID: CAKnA-A3DdwzsbTpHZtTWQRPJH_wjiUqVnTbR2nzd2K0UBX8ZBQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Dear all,

I have server as below:
- OS Debian 7.0 (Wheezy)
- CPU 24 cores
- RAM 128GB
- SSD 128GB
- 1 Gigabit Ethernet

I need to tune the Postgres with hardware specification above for my
Messaging/Messenger/Chatting Application that will run separately in
another server.

Can you give me the recommended configuration (postgresql.conf ?) for
my requirement above?

Big thanks in advance,
FattahRozzaq

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andres Freund 2015-09-02 13:53:51 Re: Allow a per-tablespace effective_io_concurrency setting
Previous Message 林士博 2015-09-01 10:25:31 Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison