jawj / zapatos

Zero-abstraction Postgres for TypeScript: a non-ORM database library
https://jawj.github.io/zapatos/
Other
1.3k stars 46 forks source link

query lock #133

Closed Kev1ntan closed 2 years ago

Kev1ntan commented 2 years ago

Hi, i suddenly got lots of query https://github.com/jawj/zapatos/blob/master/src/db/shortcuts.ts line 556 locked my postgres database

image

how to solve this issue?. thanks

jawj commented 2 years ago

Hi Kevin. Well, this isn't really enough to go on, and it's most likely not really a Zapatos issue but an issue with either Postgres or whatever software is issuing these queries.

If you can identify a complete query that reproducibly locks your database, please post it here. But, as noted above, it will probably be something to take up with the Postgres devs.