Re: Slow connection - Mailing list pgsql-general

Perhaps I missed an earlier message-- what else have you done to isolate the
problem?  In addition to the list of things I sent last week, I'd suggest
configuring your server to log all queries for a while (or even set up a
separate server for this) so that you can take a look at what queries are
actually being received by the server.

(BTW, if you do set up a separate server, do other users still experience
the slowness when you are talking to that test server?  If YES, then that
indicates that perhaps your server machine doesn't have enough resources to
accommodate the queries you are doing and other users at the same time. It
also could indicate (as others have suggested) that you've got some sort of
a machine configuration (or networking) problem.  If users DON'T experience
the same slowdowns, then I'd think you'd need to start looking at your
postgres software configuration. (Like, how many backend processes are
allowed, etc.)

We had some bizarre (read surprisingly unacceptable) performance from our
postgres server and couldn't figure out why until we turned up logging and
discovered that someone had a program stuck in a loop doing the same thing
hundreds of times/second.

-ron

> -----Original Message-----
> From: Arthur [mailto:arthur@radioretail.co.za]
> Sent: Friday, June 07, 2002 7:40 AM
> To: andrew@libertyrms.info; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Slow connection
>
>
> > On Fri, Jun 07, 2002 at 08:52:42AM +0200, Arthur wrote:
> > > 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.
> >
> >On Friday 07 June 2002 16:16, you wrote:
> > It's not clear from this whether they are experiencing general
> > network problems, of Postgres problems.  If the latter, I'd suspect
> > something your program is doing -- a transaction which is blocking
> > other operations.  If the former, I don't know.
> >
> > A
>
> Thanks for your reply, I know its a rather vague question,
> but it is a rather
> puzzling problem. I am sure its something that my program is
> doing, beacuse
> when the program stops evrything returns to normal. The LAN
> itself does not
> become slow, just all programs or users that connect to the
> postgres server
> (irrespective of the specific database).
> For example, while my program is running, using another
> interface, a query to
> a relatively small table my take about 12 seconds, but when I
> stop the
> program, it takes around 4 seconds.
>
> I can outline the basic logic of the program, maybe you can
> pick something up.
> I query a table and process the rows. For each row an update
> statement is run
> that updates data in the processed row. I use a persistant
> connection for the
> updates, but I'm not keen to do transaction batches wtih
> commit/rollback,
> etc.
>
> Is it possible that the postgres server gives precidence to
> the libpq++
> connection?
>
> thanks for your time, have a nice weekend!
>
> cheers
> Arthur
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
http://www.postgresql.org/users-lounge/docs/faq.html