Out of interest, what happens if you’ve added some custom indexes to your slurmdbd? I’ve had slow query log running on ours, and added some custom indexes for certain cases, which
has made sacct quite a lot faster for certain queries, but I worry about whether I’ve created a land-mine for future upgrades which include schema changes…. I can always delete the indexes as part of my SOP of course, and re-create them afterwards
Tim
AstraZeneca UK Limited is a company incorporated in England and Wales with registered number:03674842 and its registered office at 1 Francis Crick Avenue, Cambridge Biomedical Campus, Cambridge, CB2 0AA.
This e-mail and its attachments are intended for the above named recipient only and may contain confidential and privileged information. If they have come to you in error, you must not copy or show them to anyone; instead, please reply to this e-mail, highlighting the error to the sender and then immediately delete the message. For information about how AstraZeneca UK Limited and its affiliates may process information, personal data and monitor communications, please see our privacy notice at www.astrazeneca.com