Re: [GENERAL] Need some help on Performance 9.0.4

2013-10-18 Thread Tomas Vondra
Hi, On 18 Říjen 2013, 17:06, akp geek wrote: > when I issue the top command on solaris, what ever I have posted is > exactly > getting. > > top -n > load averages: 11.4, 10.8, 10.2;up 680+21:31:46 > 15:05:21 > 137 processes: 123 sleeping, 14 on cpu > CPU states: 82.0% idle,

Re: [GENERAL] Need some help on Performance 9.0.4

2013-10-17 Thread Tomas Vondra
On 17.10.2013 20:56, akp geek wrote: > got the output from depesz and this the top on the system. thanks for > the help .. >From depesz? That site works differently - you enter the explain plan into the form, it does some formatting/highlighting and you're supposed to submit the link to that pag

Re: [GENERAL] Need some help on Performance 9.0.4

2013-10-13 Thread Tomas Vondra
Hi, On 13.10.2013 17:43, akp geek 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

Re: [GENERAL] Need some help on Performance 9.0.4

2013-10-13 Thread bricklen
On Sun, Oct 13, 2013 at 8:43 AM, akp geek 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 perf

Re: [GENERAL] Need some help on Performance 9.0.4

2013-10-13 Thread akp geek
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 performan

Re: [GENERAL] Need some help on Performance 9.0.4

2013-10-12 Thread Michael Paquier
On Sat, Oct 12, 2013 at 12:56 AM, akp geek 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 yo

Re: [GENERAL] Need some help on Performance 9.0.4

2013-10-11 Thread John R Pierce
On 10/11/2013 8:56 AM, akp geek wrote: We have been running 4 of our applications on 9.0.4, which we are planning to update the database 9.2.2 9.0 is currently at 9.0.14, and 9.2 is currently at 9.2.5. -- john r pierce 37N 122W somewhere on the middle of

Re: [GENERAL] Need some help on Performance 9.0.4

2013-10-11 Thread John R Pierce
On 10/11/2013 9:34 AM, akp geek wrote: thanks for the help whats the question?you list what you're doing, and give a snapshot of your system state while doing some unspecified tasks. -- john r pierce 37N 122W somewhere on the middle of the left coas

Re: [GENERAL] Need some help on Performance 9.0.4

2013-10-11 Thread Steve Crawford
On 10/11/2013 08:56 AM, akp geek 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 Sorry if I missed it but I couldn't find a question or description of a problem you are encountering. Cheers, Steve -- Sent v