killing vacuum analyze process - Mailing list pgsql-general

From Julie Nishimura
Subject killing vacuum analyze process
Date
Msg-id DM6PR08MB50181EC70E5A8560E230A9DFACB90@DM6PR08MB5018.namprd08.prod.outlook.com
Whole thread Raw
Responses Re: killing vacuum analyze process
List pgsql-general
Hello there,
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 ]----+-------------------------------------------------------------------------
datid            | 2342921
datname          | symphony_middleware
pid              | 18986
usesysid         | 10
usename          | postgres
application_name |
client_addr      |
client_hostname  |
client_port      |
backend_start    | 2019-08-19 02:00:59.683198+00
xact_start       | 2019-08-19 02:03:54.191741+00
query_start      | 2019-08-19 02:03:54.191741+00
state_change     | 2019-08-19 02:03:54.191742+00
wait_event_type  | BufferPin
wait_event       | BufferPin
state            | active
backend_xid      |
backend_xmin     | 1075730757
query            | autovacuum: VACUUM ANALYZE public.resource_build (to prevent wraparound)

pgsql-general by date:

Previous
From: James Sewell
Date:
Subject: Re: Upgrade 96 -> 11
Next
From: Tom Lane
Date:
Subject: Re: killing vacuum analyze process