Re: Single user model vaccum

Ok, thank you. On Fri, Nov 6, 2020 at 10:13 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Friday, November 6, 2020, Sri Linux wrote: > >> Thank you very much David, >> No, vacuum activity wiht single-mode user is completed. I restarted all >> services and the application is onli

Re: Single user model vaccum

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

Re: Single user model vaccum

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 a

Re: Single user model vaccum

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

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 wrote: > > On Friday, November 6, 2020, Sri Linux wrote: > >> Added'' >>

Re: Single user model vaccum

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

Re: 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/100:00:00 su po