On Thu, Jan 5, 2012 at 9:22 AM, John Hodrien <[email protected]> wrote: <snip> > channels. I've done nothing else. After about a minute or two I start > getting > stuck SQL queries. Over time these build up until I run out of connections > to > postgres. > > ps lists them as "UPDATE waiting". > >> From within postgres I've done:
<snip> > Some form of locking problem? > > Database is postgresql-8.4.9-1.el6_1.1.x86_64 > > Thanks for any pointers, > > jh I have found that, in my setting, on Spacewalk 1.6 on CentOS 6.2, using pgtune, http://pgfoundry.org/projects/pgtune/, and customizing /var/lib/pgsql /data/postgresql.conf from the stock configuration file settings has improved the speed of queries and even imports (via rhnpush -- though, they still start to slow down after 3,000 file pushes). Others have found success with the stock /var/lib/pgsql/data/postgresql.conf. However, I have over 50K packages in Spacewalk, and the default postgresql config was not adequate. I am running the same version of postgresql as you. Hope that helps, but it doesn't answer your question if you have some form of locking issue or if there was a problem with your upgrade. _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
