Postgres Pro
Downloads
Home   >   mailing lists

Re: Need some help on Performance 9.0.4 - Mailing list pgsql-general

From bricklen
Subject Re: Need some help on Performance 9.0.4
Date
Msg-id CAGrpgQ_KPK8Bq8JzCDt3A=qMXD+UObSrhQ6xmUORi_+JnbBrRg@mail.gmail.com
Whole thread Raw
In response to Re: Need some help on Performance 9.0.4  (akp geek <akpgeek@gmail.com>)
List pgsql-general
Tree view
On Sun, Oct 13, 2013 at 8:43 AM, akp geek <akpgeek@gmail.com> wrote:
Sorry all not posting clear.  I posted our postresql.conf file. What we are having is very slow response from the database.

would like to get some feedback about postgresql.conf file parameters that I posted are causing the issue for performance of the DB.

Our database is about 60GB and performance is very bad. 


            pci, instance #5
    pci, instance #5
load averages:  17.5,  18.1,  18.6;                    up 673+23:00:23                  
                                                                                 16:33:58
156 processes: 140 sleeping, 16 on cpu
CPU states: 76.5% idle, 22.8% user,  0.7% kernel,  0.0% iowait,  0.0% swap
Memory: 64G phys mem, 19G free mem, 63G total swap, 63G free swap


You aren't going to get much help without some specific details about what is slow.
https://wiki.postgresql.org/wiki/Slow_Query_Questions

pgsql-general by date:

Previous
From: akp geek
Date:
Subject: Re: Need some help on Performance 9.0.4
Next
From: John R Pierce
Date:
Subject: Re: postgres 9.0.4 configuration and performance issue