Tomas Vondra <tomas.von...@enterprisedb.com> writes: > While working on a patch, I noticed that we never clean the cache of > sequence values, i.e. seqhashtab in sequence.c. That is, once we create > an entry for a sequence (by calling nextval), it will stay forever > (until the backend terminates). Even if the sequence gets dropped, the > entry stays behind.
It might be reasonable to drop entries when their sequence is dropped, though I wonder how much that would move the needle for real-world usages. Dropping an entry "just because" risks losing cached value assignments, which might be unpleasant (e.g. due to faster advancement of the sequence's counter, more WAL traffic, etc). With no actual complaints from the field, I'm disinclined to do that. regards, tom lane