Gajus Kuizinas

Results 776 comments of Gajus Kuizinas

Is there a benchmark suite I can run against my infrastructure? Happy to contribute whatever helps to identify the underlying cause. > It can be a real installation pain sometimes...

OP: No, there is not. We have since switched back to using JavaScript driver and have scaled our program a lot more. pg driver itself was never the bottleneck.

I cannot recall the specifics, but we did hit several issues with the native driver and debugging them was always a mystery. JavaScript driver has a lot more maintainers and...

To those knowledgeable about PostgreSQL in general: is there a way to enforce `statement_timeout` or another timeout even when client is in ClientRead state?

@brianc Any chance of getting a comment from you on this one? I "worked around" this by adding a cron job that kills transactions above the limit assigned to them....

``` 18:02:34 ClientRead means that the database is waiting for something from the client. 18:05:18 gajus: so here's the thing: the state is shown as "active" 18:05:46 gajus: but what...

> If you can give me a self-contained piece of code that reproduces this problem I can look at it right away. Never managed to replicate it. All I can...

The above described behaviour is unrelated to what is being reported here.

@brianc For what it is worth, I just discovered that switching to `require('pg').native` makes the issue go away.

@brianc Could you comment on whether `keepAlive` should be used? and if yes, why it is not enabled by default. In particular, I am debugging why each query starts with...