> Greetings. > > Over the last few weeks, db-koji01's load has been climbing. > We have been getting a lot of noise from our monitoring when the query > we use to monitor doesn't return fast enough. > > https://admin.fedoraproject.org/collectd/bin/index.cgi?hostname=db-koji01.phx2.fedoraproject.org&plugin=load×pan=2678400&action=show_selection&ok_button=OK > > There's very likely some upstream work to be doing adding indexes in > the right places, etc, but I think we can tune things a bit now to make > it better in the short term. > > I looked over > https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server and saw > that some of our settings were out of wack. > > I'd like to apply the below patch and restart postgresql later tonight > when things aren't as busy. If it causes some issue we can back it out, > but I hope it might improve things. > > I tried to setup the changes so they only apply to db-koji01 for now, > but after the freeze we might adjust other postgresql servers. > > +1s? > > kevin Looks good to me. +1 With kind regards, Patrick Uiterwijk Fedora Infra _______________________________________________ infrastructure mailing list infrastructure@xxxxxxxxxxxxxxxxxxxxxxx http://lists.fedoraproject.org/admin/lists/infrastructure@xxxxxxxxxxxxxxxxxxxxxxx
