BUG #14941: Vacuum crashes

From: lyes(dot)amd(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Cc: lyes(dot)amd(at)gmail(dot)com
Subject: BUG #14941: Vacuum crashes
Date: 2017-12-01 16:09:07
Message-ID: 20171201160907.27110.74730@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs pgsql-hackers

The following bug has been logged on the website:

Bug reference: 14941
Logged by: Lyes Ameddah
Email address: lyes(dot)amd(at)gmail(dot)com
PostgreSQL version: 9.6.0
Operating system: CentOs 7


I make a complete empty once a week in an automated way and it happens that
the vacuum is stuck on a table (perhaps another process has a lock first).

The behavior I would like to see is that the void ignores this table and
moves to another instead of being blocked.

Is it possible to have a solution to this problem please?
Thank you!


Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2017-12-01 16:17:23 Re: [ltree] Should `SELECT LCA('1.2', '1.2.3');` return '1.2' instead of '1'?
Previous Message Julien Grillot 2017-12-01 15:32:59 [ltree] Should `SELECT LCA('1.2', '1.2.3');` return '1.2' instead of '1'?

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2017-12-01 16:11:04 Re: [HACKERS] Constraint exclusion for partitioned tables
Previous Message Pavel Stehule 2017-12-01 16:07:04 Re: [HACKERS] proposal: psql command \graw