Purely out of curiosity, what sort of execution time do you get if you
use:
SELECT *
FROM (SELECT username,acctstarttime FROM radacct WHERE username='user'
ORDER BY acctstarttime ) allstarttimes
LIMIT 50;
Graeme Hinchliffe wrote:
>
> Now, if I do the following:
>
> SELECT username,acctstarttime
Graeme Hinchliffe <[EMAIL PROTECTED]> writes:
> If I do the following:
> SELECT username,acctstarttime FROM radacct WHERE username='user'
> ORDER BY acctstarttime;
> again the results come up slightly slower as would be expected but
> still very quickly.. (a few hundred rows in this case)
>
Hi, I am using postgres 7.4.7 under Debian Sarge for RADACCT, this means a fairly large table of data allowing us to hold approx 12 months of data. I have used a trigger to break the system in 2 and keep the live table which takes updates small, and all closed connections are inserted into a large
