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 _________________________________________________________________ La vida de los famosos al desnudo en MSN Entretenimiento http://entretenimiento.es.msn.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.
Hi,
Any suggestion for improving the throughput and accelerating the queries?
Index the tables.
Increasing database performance is usually documented on the database web site.
depending on version of PostGreSQL you may also need to 'vacuum' the database to clean up nodes etc - once again, check the database documentation site. alan
I usually execute VACUMM. But the time of the queries does not decrease. PostgreSQL 7.4> Date: Tue, 11 Mar 2008 10:39:47 +0000> From: A.L.M.Buxey@lboro.ac.uk> To: freeradius-users@lists.freeradius.org> Subject: Re: Database performance (was Re: )> > Hi,> > > > Any suggestion for improving the throughput and accelerating the queries?> > > > Index the tables.> > > > Increasing database performance is usually documented on the database> > web site.> > depending on version of PostGreSQL you may also need to 'vacuum' the database> to clean up nodes etc - once again, check the database documentation site.> > alan> -> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html _________________________________________________________________ Tecnología, moda, motor, viajes,…suscríbete a nuestros boletines para estar siempre a la última Guapos y guapas, clips musicales y estrenos de cine.
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 _________________________________________________________________ Tecnología, moda, motor, viajes,…suscríbete a nuestros boletines para estar siempre a la última http://newsletters.msn.com/hm/maintenanceeses.asp?L=ES&C=ES&P=WCMaintenance&...
participants (3)
-
A.L.M.Buxey＠lboro.ac.uk -
Alan DeKok -
Santiago Balaguer García