Re: sequence cache is kept forever

2021-11-19 Thread Tomas Vondra
On 11/19/21 18:50, Tom Lane wrote: Tomas Vondra 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 terminate

Re: sequence cache is kept forever

2021-11-19 Thread Tom Lane
Tomas Vondra 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

sequence cache is kept forever

2021-11-19 Thread Tomas Vondra
Hi, 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 stay