vacuum issues under load?

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: vacuum issues under load?
Date: 2010-01-15 05:47:57
Message-ID: Pine.LNX.4.64.1001142143100.2400@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We have recently discovered a problem with our slony-1 cluster of 8.1.19
installs. Specifically, we are unable to vacuum a table on the master
node; vacuum always hangs on the same index of the same table. If we do a
slony switchover and make the other node the master, then *it* will become
unable to vacuum that index. Vacuum on the slave always works quickly and
without issue. Vacuum does not hang anywhere else.

When we tried to strace the vacuuming backend, it appeared as if it was
trying to acquire a lock, but pg_lock showed nothing unexpected for that
index. We can also manually acquire an access exclusive lock on the
offending table if we desire. FWIW, we have about 1,000 sessions, and
while most of them are idle, we still average a couple hundred queries/s.
The index in question is a simple unique btree over a column of type
character(40).

Has anybody else experienced anything like this? We are hoping this
problem magically goes away when we upgrade to 8.4 next month, but it
would be great if we could solve it before then.

Thanks for any suggestions....

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vincenzo Romano 2010-01-15 07:51:10 Re: R: Re: R: Re: Weird EXECUTE ... USING behaviour
Previous Message Jamie Begin 2010-01-15 01:50:32 Calling a plpgsql function with composite type as parameter?