Re: Randomly slow queries over TCP, but not on localhost - Mailing list pgsql-admin

Some of the Big Brains on this list might well have some better ideas...but...

I have to tell you how many times with how many products (Apache, PostgreSQL, MySQL, Lighttpd, Tomcat, the list goes on) I have been completely screwed by forgetting to check my DNS.

You might want to ensure that:

a) The PG server has DNS properly setup. Both forward and reverse.

b) Your test client is seeing the DNS records properly, both forward and reverse.

That might not be it, but I have lost many hours of my life to forgetting about that.

---

From: pgsql-admin-owner@postgresql.org <pgsql-admin-owner@postgresql.org> on behalf of Ramiro Barreca <rbarreca@gmail.com>
Sent: Tuesday, October 6, 2015 10:39 AM
To: pgsql-admin
Subject: [ADMIN] Randomly slow queries over TCP, but not on localhost

 

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@gmail.com

Journyx, Inc.

7600 Burnet Road #300
Austin, TX 78757
www.journyx.com

p 512.834.8888 

f 512-834-8858 

Do you receive our promotional emails? You can subscribe or unsubscribe to those emails at http://go.journyx.com/emailPreference/e/4932/714/