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. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
