Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YXQBF-0002MK-KJ for pgsql-admin@arkaria.postgresql.org; Mon, 16 Mar 2015 08:15:21 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YXQBE-000053-AU for pgsql-admin@arkaria.postgresql.org; Mon, 16 Mar 2015 08:15:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YXQBD-0008WH-3I for pgsql-admin@postgresql.org; Mon, 16 Mar 2015 08:15:19 +0000 Received: from eu1sys200aog131.obsmtp.com ([207.126.144.205]) by magus.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YXQB8-0001jB-MI for pgsql-admin@postgresql.org; Mon, 16 Mar 2015 08:15:17 +0000 Received: from mail-qc0-f174.google.com ([209.85.216.174]) (using TLSv1) by eu1sys200aob131.postini.com ([207.126.147.11]) with SMTP ID DSNKVQaRDtDPhT8DDIsI0DpJCcLPOF8TfGvd@postini.com; Mon, 16 Mar 2015 08:15:14 UTC Received: by qcto4 with SMTP id o4so37005699qct.3 for ; Mon, 16 Mar 2015 01:15:10 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:from:references:in-reply-to:mime-version :thread-index:date:message-id:subject:to:cc:content-type; bh=L8YUMO8huR85nOPFhib9L8a4vz/jEj1NZaBvl2usaic=; b=hSmF19OArq3t/L0QdC9zq1+gG0czEOzqYOr0QPWUkigeD3R6h0mlyw3XUDssw/Qet1 wiptcvhTMkHeCqYiC+dFLNh94yYxMMbG9hOU7ASo/qIfQFvpLviQQ3P/DiRpL0uKarsQ ImwXsZyb3t3upia1vzNJ6Hq951ej5t+cyoHZewZViAf9JUvpKXXMm3q1xz5nMzUvZtHU R154F8S1Ei4KOe8tjBE8+LestHnk17DWuhTtEmOhlmDE7xj/Sb2cExx31vHQYCiaAH4u aH8cQ58drmX7FggVWoWGhwhU2H6FKK/2bYlwZg44Ga4H5JFx3KXpH3lU3lXzkq/Bc1we +5Xg== X-Gm-Message-State: ALoCoQmrLN+qntw0a8GplUq1r+ruPTe5rfT/Tfvfb5ERtQUT2NJWu4o0ldR3MsGWNuTPaxQ5GjrOybIxySxNEsg9Urzj9pCfygoMXSXHdrnThGB/OFcImURbQsH7IGkKS8WEaSQ6Fr9yK3IzORFp9K3wwT7/zKKBhA== X-Received: by 10.55.22.213 with SMTP id 82mr70144364qkw.103.1426493710039; Mon, 16 Mar 2015 01:15:10 -0700 (PDT) X-Received: by 10.55.22.213 with SMTP id 82mr70144348qkw.103.1426493709911; Mon, 16 Mar 2015 01:15:09 -0700 (PDT) From: Khangelani Gama References: 808fb4e2e74edd385181280ad1ed7c61@mail.gmail.com In-Reply-To: 808fb4e2e74edd385181280ad1ed7c61@mail.gmail.com MIME-Version: 1.0 X-Mailer: Microsoft Outlook 14.0 Thread-Index: AQJiCgJ0YocqW3rdp6f1KRT6RzPHXQI6lJ1gm+lvh/CAACkW8A== Date: Mon, 16 Mar 2015 10:15:08 +0200 Message-ID: <269f50be019f94b2b722198b54fff038@mail.gmail.com> Subject: Re: I am working on trying to improve a database perfomance in version 9.2 Postgresql database server To: Venkata Balaji N Cc: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=001a114904d6dabb3a0511637279 X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --001a114904d6dabb3a0511637279 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Any advices will help, see some information below: Linux is CentOS release 6.4 (Final) PostgreSQL version ? =C3=98 9.2.4 Do you have all the 103 database in one cluster ? I suspect a DISK IO and CPU spike. Do you see that ? =C3=98 Yes all 103 database are in one cluster Its hard to say straight if there is a need for REINDEXING. Can you let us know the hardware specifications of the server. We will need to understand if the server capacity is falling short for the load being received. How many active connections you see at the database level ? =C3=98 Max connections is 200 because it was giving problems with 100 max connections CONFIDENTIALITY NOTICE The contents of and attachments to this e-mail are intended for the addre= ssee only, and may contain the confidential information of Argility (Proprietary) Limited and/or its subsidiaries. An= y review, use or dissemination thereof by anyone other than the intended addressee is prohibited.If you are not the intend= ed addressee please notify the writer immediately and destroy the e-mail. Argility (Proprietary) Limited and its subsidiari= es distance themselves from and accept no liability for unauthorised use of their e-mail facilities or e-mails sent other tha= n strictly for business purposes. =0D --001a114904d6dabb3a0511637279 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Any advices will help, = see some information below:

Linux is CentOS release 6.4 (Final)

=C2=A0

PostgreSQL version ?

=C3= =98=C2=A0 9.2.4

Do you have all the 103 database in one cluster ? I suspect= a DISK IO and CPU spike. Do you see that ?

=C2=A0

=C3=98=C2=A0=C2=A0=C2=A0 Yes al= l 103 database are in one cluster

=C2=A0

I= ts hard to say straight if there is a need for REINDEXING. Can you let us k= now the hardware specifications of the server.

=C2=A0

We will need to unders= tand if the server capacity is falling short for the load being received.= =C2=A0

=C2=A0

How many active connections you see at the database level ?<= /p>

=C3=98=C2=A0 Max co= nnections is 200 because it was giving problems with 100 max connections


CONFIDENTIALITY NOTICE
The contents of and attachments to this e-mail are intended for the addre=
ssee only, and may contain the confidential
information of Argility (Proprietary) Limited and/or its subsidiaries. An=
y review, use or dissemination thereof by anyone
other than the intended addressee is prohibited.If you are not the intend=
ed addressee please notify the writer immediately
and destroy the e-mail. Argility (Proprietary) Limited and its subsidiari=
es distance themselves from and accept no liability
for unauthorised use of their e-mail facilities or e-mails sent other tha=
n strictly for business purposes.
=0D
--001a114904d6dabb3a0511637279--