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
, search_count
and on the global search.
I chose the delay somehow randomly.
History | |||
---|---|---|---|
Date | User | Action | Args |
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 |
2022-03-02 16:41:28 | reviewbot | set | messages:
+ msg74393 nosy: + reviewbot |
2022-03-02 16:17:58 | nicoe | set | keyword:
+ review reviews: 366841002 |
2022-03-02 16:15:42 | nicoe | create |
Showing 10 items. Show all history (warning: this could be VERY long)