Observing a common error in Freeradius with Postgres but not justification why it happens
Alan DeKok
aland at deployingradius.com
Sat Sep 2 13:30:02 UTC 2023
On Sep 2, 2023, at 8:19 AM, Nathan Ward <lists+freeradius at 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.
More information about the Freeradius-Users
mailing list