Matt Riedemann

> > > Are y'all using an ORM (knex, typeorm, etc) or using `pg` directly? We're not using an ORM, just `pg` directly.

> okay - and I'm guessing it happens some what "at random" meaning your app has been running for a while & then you get a timeout? Once you get...

Yeah we're setting `ssl.ca` in the options that get passed to create the pool. We're in the IBM cloud using the K8S service there to run the app and the...

Thanks for the detailed feedback and ideas of things to try. We can try (1) when that's released. Doing (2) would also be pretty easy but I'd need to tinker...

@brianc re your earlier [comment on things to try](https://github.com/brianc/node-postgres/issues/2262#issuecomment-656751203) for (3) we have a wrapper on `Pool.query` to log how long the `query` function took, i.e. this is a log...

We have something similar, everything goes through a function that wraps `Pool.query` and logs how long the original `query` function took. I've posted some code for that today in our...

We're starting to play around with `log_min_duration_statement` which defaults to 100ms in the IBM managed postgres DB instance and we definitely have queries like this taking over 1 second: `SELECT...

>In our production DB there are currently 2250262 records in that table and the task_content json blob in some of them can be relatively large (20MB). We're now actively trimming...

I've been struggling with something related in my app code lately and this would be helpful. I've got some `TIMESTAMP` fields (`WITHOUT TIME ZONE`) and I store UTC values (using...

This would probably be a good place to mention this: https://node-postgres.com/features/types In the `date / timestamp / timestamptz` section because it does mention: > node-postgres converts DATE and TIMESTAMP columns...