>
> The cpu utilization increases to nearly 100%, in user space, and stays
> there, until the database is restarted.
>
> postgres 1323 47.1 2.3 6667212 6087388 ? Rs 00:00 276:00 \_
postgres: bitbucket bitbucket 172.17.10.1(5114) SELECT
I see you have long-query logging enabled, what was th
Hi Bill,
On 13 June 2014 20:35, Bill Moran wrote:
> On Fri, 13 Jun 2014 20:02:01 +0100 Jaco Engelbrecht
> wrote:
>>
>> This coincides with a checkpoint:
>
> There's a lot going on here (as always with a busy server) but I suspected
> a checkpoint problem earlier, and this statement and your add
Yes, that would be nice, but it's a big app a lot of which we didn't write,
etc.--you can imagine the rest ;)
Is there even a way for postgreql to get me all the queries that has gone
through a particular process, so we can see what the app was trying to do
that left the connection hanging?
On T
On Fri, Jun 13, 2014 at 1:02 PM, Jaco Engelbrecht
wrote:
> hi Scott,
>
> On 13 June 2014 00:30, Scott Marlowe wrote:
>> Just the db and not the server right? Have you tried killing any
>> individual queries that seem to be problem / long running queries?
>
> We have tried to kill individual queri
On Fri, 13 Jun 2014 20:02:01 +0100 Jaco Engelbrecht
wrote:
>
> This coincides with a checkpoint:
There's a lot going on here (as always with a busy server) but I suspected
a checkpoint problem earlier, and this statement and your additional
information makes me suspect even harder.
In your ear
hi Scott,
On 13 June 2014 00:30, Scott Marlowe wrote:
> Just the db and not the server right? Have you tried killing any
> individual queries that seem to be problem / long running queries?
We have tried to kill individual queries before and it did not have any effect.
>> During this performanc
Thanks Magnus. We are using package downloaded from enterprisedb. Thanks
for the clarification.
Regards
V.S.Saravanan
On 13 Jun 2014 15:37, "Magnus Hagander" wrote:
>
>
>
> On Fri, Jun 13, 2014 at 5:25 AM, Saravanan Subramaniyan <
> sara1...@gmail.com> wrote:
>
>> Thanks Magnus. We have removed
Thanks Magnus. We have removed as well as replaced the OpenSSLlibraries.
The postgresql service is not coming up (SSL is turned off). I thought
OpenSSL is used when we turn on SSL in postgresql.
Thanks
V.S.Saravanan
On Thu, Jun 12, 2014 at 7:56 PM, Magnus Hagander
wrote:
> On Thu, Jun 12, 2014
On Fri, Jun 13, 2014 at 5:25 AM, Saravanan Subramaniyan
wrote:
> Thanks Magnus. We have removed as well as replaced the OpenSSLlibraries.
> The postgresql service is not coming up (SSL is turned off). I thought
> OpenSSL is used when we turn on SSL in postgresql.
>
PostgreSQL *uses* OpenSSL, bu