Created on 2022-03-02.16:15:42 by nicoe, last changed 2 months ago by reviewbot.
It could happen that a using a function field searcher numerous time on the search bar will result in a huge query that can take up to some hours and more importantly eat up all the memory and CPU dedicated to the database.
Thankfully postgres has an option available on the sessions:
statement_timeout that allows to limit the time spent on each statement of the session.
The review implements this on the RPC level and adds it on
search_count and on the global search.
I chose the delay somehow randomly.
|2022-04-11 17:37:54||reviewbot||set||messages: + msg75600|
|2022-03-30 16:33:44||reviewbot||set||messages: + msg74856|
|2022-03-25 20:04:04||reviewbot||set||messages: + msg74763|
|2022-03-14 19:38:23||reviewbot||set||messages: + msg74546|
|2022-03-14 18:34:04||reviewbot||set||messages: + msg74544|
nosy: + reviewbot
Showing 10 items. Show all history (warning: this could be VERY long)