Re: Slow connection

On Fri, 7 Jun 2002 08:52:42 +0200
"Arthur" <arthur@radioretail.co.za> wrote:
> Hi everybody,
> I'm developing some projects in C++ (2.96) on linux (2.4.18-3) and I connect
> to a postgres (7.2.1) database using libpq++. My connection is fine and my
> queries execute normally (and quite fast).

<plug type="gratuitous">
Have you taken a look at libpqxx?
     http://members.ams.chello.nl/j.vermeulen31/proj-libpqxx.html
</plug>

> The problem that all the other users/applications on our LAN experience
> difficulties with their connections while my program is running - ie very slow
> or timeouts.
>
> We are all accessing a central postgres server.
> My queries have no problems and as soon as I close my connection all the
> other connection on the LAN are normal, once more.
>
> Any advise or suggestions?

Sounds like a LAN problem -- AFAICT the connection to PostgreSQL
should be just like any other TCP connection. Are you transferring
a lot of data? Try simulating LAN traffic using another network
application that transfers a lot of data, and see if the problem
occurs then.

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC