Is this Streams database size and growth rate normal?

Streams

Fri, 24 Feb 2023 19:51:31 -0800 from Hypogea

Bill Statler wrote the following post Fri, 24 Feb 2023 19:51:26 -0800

Is this Streams database size and growth rate normal?
My Streams database is currently 1.15 GB and is growing steadily at about 14 MB per day. Does this sound OK or is something wrong?

I am the only active user on my instance (not counting my mom, who only uses the photo gallery). I have 49 connections. My cache size has leveled off, and gets reduced weekly by cron. But the database only grows.

@Bill Statler

Mike Macgirvin

Fri, 24 Feb 2023 20:13:48 -0800 from zap

As long as expiration is enabled, usage should flatten out. One of my sites is at 1.3G and has been reasonably steady for a couple of years. Another is at 400M but it's "relatively new" and still growing. After they flatten out, they do tend to go up a little as you add new content (which doesn't expire) and as channels are organically discovered and added to the directory.

Bill Statler

Fri, 24 Feb 2023 20:40:32 -0800 from Bunny of Doom

Okay, thanks. I'll keep an eye on it. I still have the default setting, Expiration period in days for imported streams and cached images = 60, so I can reduce that if things get too huge.

Good to hear that my own content doesn't expire. I was wondering about that.

Mike Macgirvin

Fri, 24 Feb 2023 22:22:43 -0800 from zap

It can expire, but that's for you to setup. You can find that ability in the app store if you choose it.