Re: Need some help on Performance 9.0.4

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

Regards

On Sat, Oct 12, 2013 at 7:43 AM, Michael Paquier
<michael(dot)paquier(at)gmail(dot)com>wrote:

> On Sat, Oct 12, 2013 at 12:56 AM, akp geek <akpgeek(at)gmail(dot)com> wrote:
> > We have been running 4 of our applications on 9.0.4, which we are
> planning
> > to update the database 9.2.2 by the year end. we have the streaming
> > replication also running
> 9.2.4 has fixed a severe security problem. If you do not want to
> expose your cluster to that, you should at least upgrade to this
> version.
> And posting a question would be better...
> --
> Michael
>