From: | akp geek <akpgeek(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | postgres 9.0.4 configuration and performance issue |
Date: | 2013-10-11 17:08:44 |
Message-ID: | CACnhOfKcR-85qWEa0iag4PP6uknNBARKAmvDi5WZX1TE=ftefA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
We have 4 applications ( 2 transactional , 2 ( transactional + reporting ))
on postgres 32 bit 9.0.4
Some of the queries are extreemly taking time ( 10 seconds). I can the
explain for that also.
I just want to get your thoughts on the conf file values we have are good.
Really appreciate your help.
Attachment has the postgresql.conf file ( too big to put this email ) .
Following is the detail from the top command
The top command gave us the following
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
PID USERNAME LWP PRI NICE SIZE RES STATE TIME CPU COMMAND
7041 postgres 1 0 0 3180M 3174M cpu/26 113:08 1.59% postgres
22787 postgres 1 0 0 3181M 3174M cpu/32 185:09 1.59% postgres
28199 postgres 1 0 0 3178M 3172M cpu/11 41:52 1.59% postgres
20361 postgres 1 0 0 3180M 3174M cpu/46 201:25 1.59% postgres
3768 postgres 1 0 0 3179M 3172M cpu/51 42:47 1.59% postgres
5410 postgres 1 0 0 3180M 3174M cpu/19 129:45 1.58% postgres
8183 postgres 1 0 0 3181M 3175M cpu/63 397:59 1.58% postgres
20472 postgres 1 0 0 3181M 3174M cpu/38 191:32 1.57% postgres
22793 postgres 1 0 0 3181M 3175M sleep 155:57 1.54% postgres
27811 postgres 1 0 0 3179M 3173M cpu/7 61:28 1.50% postgres
3770 postgres 1 0 0 3176M 3170M cpu/59 26:25 1.29% postgres
9473 postgres 1 0 0 3167M 3162M cpu/14 6:44 1.16% postgres
19994 postgres 1 50 0 3179M 3173M sleep 81:53 1.10% postgres
2773 postgres 1 0 0 3162M 3157M cpu/1 32:07 1.08% postgres
6356 postgres 1 0 0 3180M 3174M cpu/2 130:16 0.64% postgres
Appreciate your help
regards
Attachment | Content-Type | Size |
---|---|---|
postgresql.conf | application/octet-stream | 17.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Gavin Flower | 2013-10-11 18:47:21 | Re: Forms for entering data into postgresql |
Previous Message | akp geek | 2013-10-11 16:34:40 | Re: Need some help on Performance 9.0.4 |