Slow connection to the database
| От | Poul Møller Hansen |
|---|---|
| Тема | Slow connection to the database |
| Дата | |
| Msg-id | 433520FF.5030204@pbnet.dk обсуждение исходный текст |
| Ответы |
Re: Slow connection to the database
|
| Список | pgsql-general |
I have a problem with slow connects to a database server. In a little Java application I am starting 100 threads, each one making a database connection. The program is running on my laptop. When connecting to one server (AMD Opteron 2GHz with Solaris & pgsql version 8.0.3) the 100 connections takes 455 seconds! Comparing to an old PC (AMD K6-II 500MHz with FreeBSD and pgsql version 8.0.3) the 100 connections takes 6 seconds When running the client program on the Opteron the 100 connections takes only 1 second, but in general the network speed to/from the server is ok and they are on the same LAN. When they are connected insert and select speed are ok. Is anyone of you having an idea where to seek the problem ? Regards, Poul
В списке pgsql-general по дате отправления: