Does auth.users ever clean itself? Like does it au...
# off-topic
d
Does auth.users ever clean itself? Like does it auto remove rows where email_confirmed_at == null or something? after x amount of time?
g
I don't believe so. pg_cron is an optional extension so that is not being used and I have 2 month old fake users sitting with out email confirmed.
d
That makes sense. Dose the
token
in the URL have an expiration?
g
24 hours I'm pretty sure. Same for magic links.
d
Makes sense !
So it's only worth doing cleanup if those dead rows take up a lot of space, right?
g
I'm more worried about the auth.refresh_tokens table... but I figure other large players will hit it and some resolution will come up before I get there. I've not researched it though.
d
Hmm
g
Worried is probably too strong, I've just noticed it and thought may want to clean it myself some day with chron.
d
Yeah I get that. Seems like a problem that'll come from being successful lol
g
The size of that table is probably the least of your worries if you have that many users...
Indexes and RLS optimization will come first...
d
Yeah absolutely . Thanks