No title
Is there any option to run reindex or vaccum in background?
Every time the session gets logged off in between.
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
Show quoted text
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.
On Tue, Aug 27, 2019 at 11:59 PM Sonam Sharma <sonams1209@gmail.com> wrote:
Is there any option to run reindex or vaccum in background?
Every time the session gets logged off in between.
There is not - though you can make your auto-vacuum parameters super
aggressive.
I'm having trouble imagining a scenario where running reindex or vacuum
arbitrarily at session end would be a useful thing.
David J.
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