Re: Single user model vaccum - Mailing list pgsql-general

From Sri Linux
Subject Re: Single user model vaccum
Date
Msg-id CAFcfow_8Dtsy+Y6cmfwdYHtjTWVUUrwTr6kewn6STJvCmXhqNA@mail.gmail.com
Whole thread Raw
In response to Re: Single user model vaccum  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Single user model vaccum
List pgsql-general
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.g.johnston@gmail.com> wrote:

On Friday, November 6, 2020, Sri Linux <srilinux09@gmail.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@gmail.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.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Single user model vaccum
Next
From: "David G. Johnston"
Date:
Subject: Re: Single user model vaccum