Re: Problems with query in highly concurrent environment - Mailing list pgsql-general

From Jim Wilson
Subject Re: Problems with query in highly concurrent environment
Date
Msg-id 200502250045.j1P0jrF4031001@linus.kelco1.com
Whole thread Raw
In response to Problems with query in highly concurrent environment  (Aleksei Valikov <valikov@gmx.net>)
List pgsql-general
> From: Aleksei Valikov
>
<snip>
> Moreover, what I find very strange is that when I log in with psql (or
> any other SQL client) onto the production database and execute the same
> query, it runs fast - even in peak hours!
>
<snip>

That is strange.  Is this a networking issue?  Are your clients becoming memory
bound (e.g. not enough RAM or poor garbage collection/memory leakage on the
client side)?

Best regards,

Jim Wilson



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Pg 8.0rc5 to 8.0.1 update
Next
From: Bruce Momjian
Date:
Subject: Re: Possible to run the server with ANSI/ISO string escapeing