db performance

Peter Nixon listuser at peternixon.net
Fri May 18 00:40:10 CEST 2007


On Thu 17 May 2007, A.L.M.Buxey at lboro.ac.uk wrote:
> Hi,
>
> > Unless you are doing monthly or yearly summary reports which can take a
> > lightly loaded DB server and peg it for minutes at a time...
> >
> > The lesson.. Keep a second DB for reporting :-)
>
> or use a DB that can handle non-blocking selects? <ducks> ;-)

I use PostgreSQL... I didnt say that it stops the DB or queries.. Just that 
it "works" it in a way the FreeRADIUS will not. If the report is big enough 
and you have a heavy enough RADIUS load, it _can_ be enough load to push 
your box over the limit and start timing out requests...

-- 

Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc



More information about the Freeradius-Users mailing list