PostgreSQL 7.4.1 incredibly slow :-(
От | Carlos Moreno |
---|---|
Тема | PostgreSQL 7.4.1 incredibly slow :-( |
Дата | |
Msg-id | 3FF8B69B.7090005@mochima.com обсуждение исходный текст |
Ответы |
Re: PostgreSQL 7.4.1 incredibly slow :-(
Re: PostgreSQL 7.4.1 incredibly slow :-( |
Список | pgsql-general |
Hi, I'm experiencing some really odd behaviour after upgrading to postgresql 7.4.1 We have three different machines: 1) Dual Athlon, 1GB RAM running RedHat 7.3 with all the updates (kernel, glibc, gcc/g++ 2.96-113) 2) Single Pentium 1.7GHz, 512M RAM running RedHat 9 with all the updates. 3) Single Pentium 2GHz, 512M RAM running RedHat 7.3 with all the updates, and the compiler updated from the source to gcc/g++ 3.2.2 We upgraded all of them to postgresql 7.4.1, installed with: ./configure make make install (i.e., all the default options) Everything except local (i.e., non-TCP/IP) connections has md5 authentication (this for the three machines). On the dual Athlon (Murphy had to do it in a way that maximizes the irony, of course! :-)), connections through TCP/IP take forever! Even if they're local connections (i.e., even if they come from 127.0.0.1) If I run psql locally, when executed without switches, it responds instantly (pg_hba.conf has an entry with "ident sameuser" for local connections). When executed with the -h localhost switch, it takes exactly 30 seconds to prompt me for the password, and once I enter the password, it takes another 30 seconds (*exactly* 30 seconds). The pg_hba.conf files are identical (in fact, *really* identical, as I discovered that TCP/IP connections to the same machine are not seen by the server as coming from 127.0.0.1, but coming from the other IP address -- the "public" one; so I had to add each machine's own addresses to the pg_hba.conf). It doesn't look like it is RedHat's version making a difference -- two of the machines have 7.3, and on one of them, everything runs instantly)... Hmmm, the compiler seems to be the only difference between the two RH7.3 machines. I doubt it has to do with firewalls (for one, the connections are passing -- ipchains firewalls do not simply add a delay; but also, it was working without any delay before upgrading to 7.4.1) Any ideas of what this could be? Any extra validations or constraints in the new server-to-client protocol? Those 30 seconds sound like a timeout of some sort, but whatever it may be, it was not affecting the previous setup, so I can't figure out what it could be that I need to change. Thanks for any ideas! Carlos --
В списке pgsql-general по дате отправления: