Database performance (was Re: )

[Alan DeKok <aland@deployingradius.com>]

Santiago Balaguer García wrote:
>   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?

  Index the tables.

  Increasing database performance is usually documented on the database
web site.

  Alan DeKok.