[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
bug#43850: cuirass: inconsistent SQL queries execution time.
From: |
Mathieu Othacehe |
Subject: |
bug#43850: cuirass: inconsistent SQL queries execution time. |
Date: |
Sun, 01 Nov 2020 19:23:14 +0100 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) |
Hey Maxim,
> Perhaps we should run 'vacuum' when invoking 'guix gc' or at some other
> key places (where lots of data gets removed from the DB). There's also
> the auto_vacuum PRAGMA, which is not enabled currently:
Vacuuming periodically seems important, however, it didn't resulted in
noticeable improvements during high I/O pressure when I tested it.
I still think that we should vacuum periodically, even though it means
that all database writes are postponed during the duration of the
vacuuming.
Having a separate fiber in charge of that operation could work I guess.
Thanks,
Mathieu
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- bug#43850: cuirass: inconsistent SQL queries execution time.,
Mathieu Othacehe <=