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

On Sep 2, 2023, at 8:19 AM, Nathan Ward <lists+freeradius@daork.net> wrote:

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 Alan DeKok.