Postgres Pro
Downloads
Home   >   mailing lists

PostgreSQL Tuning for Messaging/Messenger/Chatting Application - Mailing list pgsql-performance

From FattahRozzaq
Subject PostgreSQL Tuning for Messaging/Messenger/Chatting Application
Date
Msg-id CAKnA-A3DdwzsbTpHZtTWQRPJH_wjiUqVnTbR2nzd2K0UBX8ZBQ@mail.gmail.com
Whole thread Raw
Responses Re: PostgreSQL Tuning for Messaging/Messenger/Chatting Application
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: 林士博
Date:
Subject: Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
Next
From: Volker Böhm
Date:
Subject: query with pg_trgm sometimes very slow