Database performance (was Re: )

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.