feat(core, postgres): Add RunFunctionWaitStrategy and use it in pg

feat(core, postgres): Add RunFunctionWaitStrategy and use it in pg #1396