How to manage query priority in postgresql?

Question

linux

There is a server on debian with postgresql. There are two bases. In one, there are always a lot of requests for writing, updating, and selects. In the second, a batch of samples periodically falls down, a little recording. The problem is that those who are in second base carry the money. And they haven't brought it to a separate server yet. Is it possible to do something so that requests to the second base are processed with high priority, and for the first time they are even suspended when they break into the second one? Or all the same it is necessary to resolve at the level of applications?

Answer 1

Unfortunately, this is not provided in the database itself https://wiki.postgresql.org/wiki/Priorities

Answer 2

Divide databases by different DBMS. If a separate server is not an option (which is odd in a commercial project), make two containers with different quotas.