An early look at Postgres 14: Performance and monitoring Improvements

Re:An early look at Postgres 14: Performance and monitoring ... by znep on Saturday May 22, 2021 @03:42PM (#27249673)

I agree this is a great addition, but FWIW it isn't normal for ^C to not work in psql. Perhaps you are using some other client that doesn't support aborting queries properly, or have something on the network between you and the server behaving poorly and dropping connections?

[ Parent | on HN ]

Re:An early look at Postgres 14: Performance and monitoring ... by efxhoy on Saturday May 22, 2021 @07:54PM (#27251292)

It's psql through an ssh-tunnel to RDS on AWS, postgres 10.6 usually. But I've had the same experience on other versions and locally too.

The problem usually isn't that it doesn't work ever, just that it can take a very long time, especially if the query is reading some crazy amount of data. I've always found pg_cancel_backend() to be almost instant though.

[ Parent | on HN ]

Re:An early look at Postgres 14: Performance and monitoring ... by salmo on Saturday May 22, 2021 @08:46PM (#27251552)

Sounds like it's ^C on a client that doesn't trap SIGTERM and cleanup. Probably something they're working on.

[ Parent | on HN ]