I'm running a custom-compiled build of PostgreSQL on Solaris 8 with
vacuum full analyze being run every hour. It runs fine, but after a few
days of running even simple operations like create table slow down, and
eventually they never return. When this occurs, a vacuum will _also_
hang.

The solution is to cycle PostgreSQL; the restarted version runs nice &
quickly. Anyone have any idea what could cause this?

--
Robert Uhl <http://public.xdi.org/=ruhl>
That was possibly the only time in my entire career that somebody actually
noticed and cared to say that they were impressed by something I'd achieved.
These days, I could turn lead into gold, and I'd be whinged at because they
wanted platinum. --Peter Corlett