<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
I usually execute VACUMM. But the time of the queries does not decrease.<BR>
<BR>
PostgreSQL 7.4<BR><BR>> Date: Tue, 11 Mar 2008 10:39:47 +0000<BR>> From: A.L.M.Buxey@lboro.ac.uk<BR>> To: freeradius-users@lists.freeradius.org<BR>> Subject: Re: Database performance (was Re: )<BR>> <BR>> Hi,<BR>> <BR>> > > Any suggestion for improving the throughput and accelerating the queries?<BR>> > <BR>> > Index the tables.<BR>> > <BR>> > Increasing database performance is usually documented on the database<BR>> > web site.<BR>> <BR>> depending on version of PostGreSQL you may also need to 'vacuum' the database<BR>> to clean up nodes etc - once again, check the database documentation site.<BR>> <BR>> alan<BR>> -<BR>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html<BR><BR><br /><hr />Sigue de cerca las últimas tendencias y lo que más rompe <a href='http://video.msn.com/video.aspx?mkt=es-es' target='_new'>MSN Vídeo</a></body>
</html>