Single user model vaccum

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

Thanks,
Sri

On Fri, Nov 6, 2020 at 8:17 PM Sri Linux <srilinux09@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.

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:

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?

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 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: