Well... I tried to connect with psql -h 127.0.0.1 mydb and it's slow (+/- 5 sec.) and psql mydb is fast ( less than 1 sec.) !
Here is my pg_hba : .. few comments... local all trust host all 127.0.0.1 255.255.255.255 trust host all my_ip 255.255.255.255 trust where my_ip is an IP address May be I have a probleme with my system ? version of the kernel is 2.4 jean-arthur At 18:55 24/06/02 -0400, Tom Lane wrote: >Jean-Arthur Silve <[EMAIL PROTECTED]> writes: > > I have a httpd server on one server, and PostgresQL 7.2 on a second server > > (P4 1.7 Ghz / Linux ) on a local network. > > > When there are about 20 (and more ) connection on the DB, the remote > > connecxtion to the DB from the web server is very long (about 5-10 sec) > > before have the prompt. > > > On the local machine, it's near immediate. > >Weird. Perhaps something wrong with your DNS setup, causing it to take >a long time to resolve the name of the other machine? Anyway I'd >suspect that the problem is not within Postgres proper, given that >you're not seeing a performance problem with local connections. > >Another thing you might try just to obtain more data is to test local >connections that use TCP rather than Unix-socket transport, eg > psql -h 127.0.0.1 > > > I use IP authentification (no username/password). > >You mean "trust"? Please describe your pg_hba contents *exactly*; >this might be a relevant difference ... > > regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
