By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,109 Members | 993 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,109 IT Pros & Developers. It's quick & easy.

Performance Issues PostgreSQL on Solaris

P: n/a
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
Apr 14 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.