Problems with vacuum

From: JotaComm <jota(dot)comm(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Problems with vacuum
Date: 2013-09-04 14:57:26
Message-ID: CAA8OQ68sjoJnP7oKebKKZB60b_Qcphb_MRV73ZfM3d6TVBJ-jg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello, everbody

I have the following problem: My vacuum is running since 2013-08-27 18:58:
41.527238-03.

billing=# SELECT localtimestamp(0);
-[ RECORD 1 ]------------------
timestamp | 2013-09-04 11:23:06

billing=# SELECT pg_stat_activity.procpid,pg_
stat_activity.current_query,pg_stat_activity.query_start FROM
pg_stat_activity WHERE pg_stat_activity.current_query ~ 'public.mensagem'
AND pg_stat_activity.procpid!=pg_backend_pid();
-[ RECORD 1 ]-+-----------------------------------------------------------
procpid | 2738
current_query | autovacuum: VACUUM public.mensagem (to prevent wraparound)
query_start | 2013-08-27 18:58:41.527238-03

I tried to cancel it but unsuccessful.

billing=# SELECT pg_cancel_backend(2738);
-[ RECORD 1 ]-----+--
pg_cancel_backend | t

billing=# SELECT localtimestamp(0);
-[ RECORD 1 ]------------------
timestamp | 2013-09-04 11:23:18

billing=# SELECT
pg_stat_activity.procpid,pg_stat_activity.current_query,pg_stat_activity.query_start
FROM pg_stat_activity WHERE pg_stat_activity.current_query ~
'public.mensagem' AND pg_stat_activity.procpid!=pg_backend_pid();
-[ RECORD 1 ]-+-----------------------------------------------------------
procpid | 2738
current_query | autovacuum: VACUUM public.mensagem (to prevent wraparound)
query_start | 2013-08-27 18:58:41.527238-03

Any idea? Any tips?

Best regards

--
JotaComm
http://jotacomm.wordpress.com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Igor Neyman 2013-09-04 15:08:10 Re: Problems with vacuum
Previous Message boraldomaster 2013-09-04 10:55:51 Re: Postgres 9.1 statistics in pg_stat_database