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@xxxxxxxxx> wrote:
On Friday, November 6, 2020, Sri Linux <srilinux09@xxxxxxxxx> 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 postgresOn Fri, Nov 6, 2020 at 8:17 PM Sri Linux <srilinux09@xxxxxxxxx> wrote:Hi AllHow 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.
