Re: Need some help on Performance 9.0.4

Поиск
Список
Период
Сортировка
От akp geek
Тема Re: Need some help on Performance 9.0.4
Дата
Msg-id CACnhOf+5yd=sUYHOz7yeFS73Ab6VRBxHWMw3rwq-y1RRDWGPKA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Need some help on Performance 9.0.4  (Michael Paquier <michael.paquier@gmail.com>)
Ответы Re: Need some help on Performance 9.0.4  (bricklen <bricklen@gmail.com>)
Re: Need some help on Performance 9.0.4  (Tomas Vondra <tv@fuzzy.cz>)
Список pgsql-general
Дерево обсуждения
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.paquier@gmail.com> wrote:
On Sat, Oct 12, 2013 at 12:56 AM, akp geek <akpgeek@gmail.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

В списке pgsql-general по дате отправления:

Предыдущее
От: akp geek
Дата:
Сообщение: Re: postgres 9.0.4 configuration and performance issue
Следующее
От: bricklen
Дата:
Сообщение: Re: Need some help on Performance 9.0.4