Performance Issues PostgreSQL on Solaris

Question posted by: Robert Uhl (Guest) on April 14th, 2006 03:15 PM

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

Not the answer you were looking for? Post your question . . .
189,847 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).