From: | Tory M Blue <tmblue(at)gmail(dot)com> |
---|---|
To: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | 9.3 performance issues, lots of bind and parse log entries |
Date: | 2014-11-04 17:01:41 |
Message-ID: | CAEaSS0a+68JcGO9L=wFPNmtHZF4MUyA-tg3WZZT5niWmnRW0bA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Not sure what is going on but other than upgrading to 9.3.4 from 9.2.4, i'm
seeing major slowness in basic queries and seeing a ton of the bind and
parse in my logs. These are standard lookups and should take micro seconds.
I'm logging all queries that take over a second and this seems to be
getting worse, seems like it's snowballing.
2014-11-04 08:54:52 PST clsdb cls 216.0.0.50(33569) 14857 2014-11-04
08:54:52.476 PSTLOG: duration: 2206.070 ms parse dbdpg_p12768_2: SELECT
contact_seq_id, status FROM cls.contacts
WHERE
cust_seq_id = $1
AND contact_id = $2
2014-11-04 08:54:52 PST clsdb cls 216.20.0.50(48450) 14882 2014-11-04
08:54:52.394 PSTLOG: duration: 1624.847 ms bind dbdpg_p21610_2: SELECT
contact_seq_id, status FROM cls.contacts
WHERE
cust_seq_id = $1
AND contact_id = $2
CentOS 6.x
Postgres: 9.3.4
256GB Mem
32Core
I'm tearing up my system to see what is happening, the postgres is the only
change, the processes or the data is not. I tried tuning postgresql.conf
and modifed effective cache etc, but I've reverted it all, so again just
looking for some assistance.
Again no I/O have plenty of memory etc. The server is running hotter than
it used to as well.
Thanks
Tory
From | Date | Subject | |
---|---|---|---|
Next Message | jmcdonagh | 2014-11-04 18:59:32 | Re: Incredibly slow restore times after 9.0>9.2 upgrade |
Previous Message | jmcdonagh | 2014-11-04 16:28:05 | Re: Incredibly slow restore times after 9.0>9.2 upgrade |