Re: Observing a common error in Freeradius with Postgres but not justification why it happens

...

I don’t think you shared how many rows you have, but, 8GB of rows will be a lot.

Yup.

...

If you need this data to be retained, my suggestion is that you get someone experienced with postgres to help you design this DB and the queries.

A simple thing is to have one database for current information (e.g. last month or so), and a separate database for historical information.

I write articles about this: https://networkradius.com/articles/2022/05/24/split-historical-database.html

Thanks Alan, I will give it a check for sure. Best regar