Of course, if your PG server is running on a virtual machine, increasing hardware resources can also be an emergency option.

You can find an example of that here: Examples Misuse of this procedure can harm performance. Be very careful about introducing observer overhead, especially when gathering query plans. Be even more ...