Re: Slow connection

On Fri, 7 Jun 2002, Ron Snyder wrote:

> My inclination as a sysadmin type is to first isolate the problem to either
> your program, or the queries that your program is performing.  To do that, I
> would try running your program from some other machine and see if it has the
> same effect.  If it doesn't, I'd suspect something wrong with the way your
> machine is communicating with the machine the server is running on.
>
> [edited to keep short]
>
> > -----Original Message-----
> > From: Arthur [mailto:arthur@radioretail.co.za]
> > Sent: Thursday, June 06, 2002 11:53 PM
> > To: pgsql-general@postgresql.org
> > Subject: [GENERAL] Slow connection
> >
> >
> > 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).
> >
> > 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?

I'd see what network traffic you're generating as well if it's bring your LAN
to it's knees.


--
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants