Обсуждение:

Hi,


if you have access to the OS, then you have plenty of options.

Else, I think pg_cron might do the job


regards,

fabio pardi



On 28/08/2019 08:58, Sonam Sharma wrote:
> Is there any option to run reindex or vaccum in background?
> Every time the session gets logged off in between.

Sonam Sharma <sonams1209@gmail.com> writes:
> Is there any option to run reindex or vaccum in background?
> Every time the session gets logged off in between.

If your session is getting killed by a network idle-time timeout,
you could probably prevent that with suitable adjustment of the
server's TCP-keepalive settings.

            regards, tom lane