RE: Database performance (was Re: )

To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org>
Subject: RE: Database performance (was Re: )
From: Santiago Balaguer García <santiagoawa@hotmail.com>
Date: Tue, 11 Mar 2008 14:02:43 +0000
Importance: Normal
In-reply-to: <20080311103947.GB13181@lboro.ac.uk>
References: <BAY143-W182C09AE974E40FBEE5AE1B00F0@phx.gbl> <47D63EA7.9090109@deployingradius.com> <20080311103947.GB13181@lboro.ac.uk>
Reply-to: FreeRadius users mailing list <freeradius-users@lists.freeradius.org>

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

Sigue de cerca las últimas tendencias y lo que más rompe MSN Vídeo

References:
- [no subject]
  - From: Santiago Balaguer García <santiagoawa@hotmail.com>
- Database performance (was Re: )
  - From: Alan DeKok <aland@deployingradius.com>
- Re: Database performance (was Re: )
  - From: A.L.M.Buxey@lboro.ac.uk

Previous by Date: Can freeRadius do that?
Next by Date: Re: Can freeRadius do that?
Previous by Thread: Re: Database performance (was Re: )
Next by Thread: RADIUS database growing up
Freeradius-Users March 2008 archives indexes sorted by: [ thread ] [ subject ] [ author ] [ date ]
Freeradius-Users list archive Table of Contents
More information about the Freeradius-Users mailing list

This archive was generated by a fusion of Pipermail (Mailman edition) and MHonArc.