Steve Bertrand <[email protected]> wrote:
>
>>> The radacct table in the RADIUS database grows at an enormously fast
>>> rate. Regardless of server resources, trying to search or perform
>>> actions on this table can be a daunting task.
>>
>> Yup. In some cases, people are required to keep this data for months.
>
> I have all radacct information back to 1999 readily available, and data
> before that archived. It wasn't until ~2003 or so that I changed to
> using SQL. It didn't take long to realize that the SQL server became
> useless after only a few months.
>
I guess I am a 'small cheese' with only 2m rows in my authentication
table? I am using PgSQL and have btree'd my timestamp columns, but it
still takes only 3.6s to pull 10k rows worth of just todays data.
I thought the point of index'ing your columns (sensibly) meant that the
size of the table was not meant to really be too much of a killer?
Cheers
--
Alexander Clouter
.sigmonster says: Cure the disease and kill the patient.
-- Francis Bacon
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
