[no subject]

To: Lista de correo RADIUS <freeradius-users@lists.freeradius.org>
Subject:
From: Santiago Balaguer García <santiagoawa@hotmail.com>
Date: Tue, 11 Mar 2008 08:07:52 +0000
Importance: Normal
Reply-to: FreeRadius users mailing list <freeradius-users@lists.freeradius.org>

Hi,

I have two radius server since three years ago. They are my two production AAA servers and can authenticate until 300.000 accounts. So my RADIUS database (PostgreSQL) grew up enough and I realize that my SQL queries slow down. I know that I have four table with almost 500.000 registers each one.

Any suggestion for improving the throughput and accelerating the queries?

Thanks,

Santiago

Sigue los principales acontecimientos deportivos en directo. MSN Motor

Follow-Ups:
- Database performance (was Re: )
  - From: Alan DeKok <aland@deployingradius.com>
- RADIUS database growing up
  - From: Santiago Balaguer García <santiagoawa@hotmail.com>

Previous by Date: Re: Rule for don't log specific user session.
Next by Date: Database performance (was Re: )
Previous by Thread: Re:
Next by Thread: Database performance (was Re: )
Freeradius-Users March 2008 archives indexes sorted by: [ thread ] [ subject ] [ author ] [ date ]
Freeradius-Users list archive Table of Contents
More information about the Freeradius-Users mailing list

This archive was generated by a fusion of Pipermail (Mailman edition) and MHonArc.