Julie Nishimura writes:
> Thank you Tom. I can see bunch of old processes running ROLLBACK... Should I
> kill them or they only way to clear those is to restart the server?
As Ron pointed out, those processes aren't actually running ROLLBACK;
that was just their last query. They're idle (and no
a
*Cc:* pgsql-general@lists.postgresql.org
*Subject:* Re: killing vacuum analyze process
Julie Nishimura writes:
> PostgreSQL 9.6.2 on x86_64-pc-linux-gnu
> It seems like we have one process running since 8/19. Is it any
repercussion if we kill it?
> postgres=# select * from
| ROLLBACK
(7 rows)
From: Tom Lane
Sent: Tuesday, September 3, 2019 4:11 PM
To: Julie Nishimura
Cc: pgsql-general@lists.postgresql.org
Subject: Re: killing vacuum analyze process
Julie Nishimura writes:
> PostgreSQL 9.6.2 on x86_64-pc-linux-gnu
> It seems like we hav
Julie Nishimura writes:
> PostgreSQL 9.6.2 on x86_64-pc-linux-gnu
> It seems like we have one process running since 8/19. Is it any repercussion
> if we kill it?
> postgres=# select * from pg_stat_activity where pid = '18986';
> -[ RECORD 1
> ]+--
