From: | Ramiro Barreca <rbarreca(at)gmail(dot)com> |
---|---|
To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Randomly slow queries over TCP, but not on localhost |
Date: | 2015-10-06 15:39:49 |
Message-ID: | CAO4Rs2=nMkv=Un05YF0T8aW2V+ww=8V=Zi-gmqEmdD=Jf=QUZA@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
We have a
* PG 8.4 server
* 16GB RAM
* 16 CPU cores
* Linux Centos 5 (2.6.18-406.el5.centos.plus kernel)
* max_connections: 800 (but never over 500. usually 300 to 400)
WE have detected randomly slow connections when accessing through the
network (not at localhost)
We use a script with a loop calling the psql command running a simple
"select 1 from table".
At localhost, the conection is a flash, showing in very few ms the result
on screen.
When passing the parameter "-h" with its own IP addres it begin answering
immediately, but suddenly it has a delay of 10 seconds or more to answer on
1 or 2 of 10 commands.
Our suspect is that ther is a problem with the network stack parameter,
perhaps at kernel level.
May it be the truth?
Ramiro Barreca
rbarreca(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Whitney | 2015-10-06 15:48:47 | Re: Randomly slow queries over TCP, but not on localhost |
Previous Message | Bruce Momjian | 2015-10-06 14:15:23 | Re: pg_upgrade from 9.3 to 9.4 fails |