RFC 2866 - Accounting ON / Accounting OFF packets
A.L.M.Buxey at lboro.ac.uk
A.L.M.Buxey at lboro.ac.uk
Thu Mar 13 21:08:16 CET 2008
Hi,
>> Also the index 'acctsessiontime' is missing for the radacct table in the
>> default schema; makes the Accounting-On / Accounting-Off queries very slow
>> doing a table scan on 1.4 million rows... Is this intentional or an
>> oversight ?
>
> In the postgres schema, there's a conditional compound index which makes
> that query fast/indexed, so I suspect it's an oversight.
postgres is, in general, so much better from a default install too.
we spent some time tweaking the MySQL...but a trivial side-grade
to using postgres paid immediate dividends... non-blocking
inserts/updates etc. very nice.
alan
More information about the Freeradius-Users
mailing list