Thread: Single user model vaccum
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.
Please advise.
Regards
Sri
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
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
Thanks,
Sri
On Fri, Nov 6, 2020 at 8:17 PM Sri Linux <srilinux09@gmail.com> 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.Please advise.RegardsSri
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 postgresOn Fri, Nov 6, 2020 at 8:17 PM Sri Linux <srilinux09@gmail.com> 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.
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 postgresOn Fri, Nov 6, 2020 at 8:17 PM Sri Linux <srilinux09@gmail.com> 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.
On Friday, November 6, 2020, Sri Linux <srilinux09@gmail.com> wrote:
Thank you Davidvacuum is done but the application is very slow, is this normal behavior? Will it run any background process after vacuum causing this slowness?
Please don’t top-post.
Are you still running under single-user?
David J.
Thank you very much David,
No, vacuum activity wiht single-mode user is completed. I restarted all services and the application is online but pretty slow.I will open a new case but confused about how to do a new post in the Postgres community.
is this common for an application to run pretty slow after vacuum without any other option like full etc.
Regards
Sri
On Fri, Nov 6, 2020 at 9:55 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Friday, November 6, 2020, Sri Linux <srilinux09@gmail.com> wrote:Thank you Davidvacuum is done but the application is very slow, is this normal behavior? Will it run any background process after vacuum causing this slowness?Please don’t top-post.Are you still running under single-user?David J.
On Friday, November 6, 2020, Sri Linux <srilinux09@gmail.com> wrote:
Thank you very much David,No, vacuum activity wiht single-mode user is completed. I restarted all services and the application is online but pretty slow.I will open a new case but confused about how to do a new post in the Postgres community.is this common for an application to run pretty slow after vacuum without any other option like full etc.
There isn’t a process for “opening a new case”. You just send an email.
David J.
Ok, thank you.
On Fri, Nov 6, 2020 at 10:13 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Friday, November 6, 2020, Sri Linux <srilinux09@gmail.com> wrote:Thank you very much David,No, vacuum activity wiht single-mode user is completed. I restarted all services and the application is online but pretty slow.I will open a new case but confused about how to do a new post in the Postgres community.is this common for an application to run pretty slow after vacuum without any other option like full etc.There isn’t a process for “opening a new case”. You just send an email.David J.