Re: [TIPS] Tuning PostgreSQL 9.2

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com>
Cc: Payal Singh <payal(at)omniti(dot)com>, Scott Whitney <scott(at)journyx(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [TIPS] Tuning PostgreSQL 9.2
Date: 2016-02-21 18:34:30
Message-ID: CAOR=d=3rDxobmRd7mgmQV1F1avWRjFQ3gkikFA9o1PmvqYRJgg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I also noticed you're running RHEL 6.x which runs on the truly ancient
(but pretty reliable) 2.6.32 kernel. The newer 3.11 and 3.13 kernels
are MUCH faster at IO and a lot smarter about caching and when to swap
etc. I've seen several big machines go from a few thousand tps to 15
to 20k tps just from going from 3.2 to 3.13. Keep us updated on
whether or not a pooler works for you.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Venkata Balaji N 2016-02-22 04:12:50 Re: PostgreSQL 9.3.5 - Enable SSL
Previous Message Venkata Balaji N 2016-02-21 09:58:33 Re: PostgreSQL 9.3.5 - Enable SSL