Re: Single user model vaccum

Thank you David

vacuum is done but the application is very slow, is this normal behavior?
Will it run any background process after vacuum causing this slowness?

Thanks
Sri

On Fri, Nov 6, 2020 at 9:15 PM David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
wrote:

>
> On Friday, November 6, 2020, Sri Linux <srilinux09(at)gmail(dot)com> wrote:
>
>> Added''
>>
>> when I log in to the Linux terminal and grep process, I can only see the
>> single-user mode process running but not sure about vacuum status. I can't
>> run a pg_stat commands from pgsql as the db is in single-user mode.
>>
>> ps -ef|grep -i sql
>> root 25412 15199 0 14:59 pts/1 00:00:00 su postgres -c
>> /usr/pgsql-9.4/bin/postgres --single -O -D /pgsql/9.4/data postgres
>> postgres 25413 25412 53 14:59 ? 02:50:00
>> /usr/pgsql-9.4/bin/postgres --single -O -D /pgsql/9.4/data postgres
>>
>> On Fri, Nov 6, 2020 at 8:17 PM Sri Linux <srilinux09(at)gmail(dot)com> wrote:
>>
>>> Hi All
>>>
>>> How can I monitor and make sure that the vacuum is still running if I
>>> get lost with the session to Linux putty? I would need to check if the
>>> vacuum is still running from Linux OS.
>>>
>>
> Don’t really know but a quick read suggests you will need to basically
> debug the running process.
>
> In the future use something like “screen” or “tmux” so you can just
> re-attach to the terminal container.
>
> I’m not sure if there is anything special about single-user mode (way to
> omit critical info on your first two emails) that would discourage you from
> just killing the server and starting a new vacuum.
>
> David J.
>
>