On Tue, Aug 18, 2020 at 12:29:49PM +0200, Tomas Kopecek wrote:
What are your experiences with db performance tuning? I'm
thinking about
which indices we use internally and which of them are worthy to create in
default installations. Similar situation is with partitioning, clustering
and few other things we can do. But most of these are probably beneficial
only with big deployments (Few versions ago I've started docs about db
which now contains only partitioning). Is there something you would like to
see related to db maintenance/performance?
/ Followup of
https://pagure.io/koji/pull-request/2419 /
I've done a ton of tuning on the fedora koji db host, but I am not sure
I would say much of it is koji specific, more general postgresl tuning.
In general I would say more indexes and better queries helps everyone,
so should be golbally enabled/landed.
There was some talk a while back about requiring newer postgresql
versions (perhaps for native json object support?), perhaps thats
something to revisit now that python2 has gone away for hubs and thus
likely means most installs are going to be moving to rhel8/newer fedora.
I've not done partitioning (because at the time our postgres was too old
to do it, but might persue that again). Some basic info on clustering
might be nice, but not sure koji should get too deep into postgres setup
info...
kevin