Re: [SQL] index and min()

2003-10-26 Thread Christopher Browne
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] transmitted: > SELECT min(inserttime) FROM acc_pb; which takes about 11 seconds to > complete. > > On the mssql server this takes less than 1 second. If you have NO index on inserttime, then the best that can be done is the se

[SQL] index and min()

2003-10-26 Thread sarek
Hello, I have a table that contains logs from a radius accounting server. Currently the table contains 1,780,470 rows and is about 350Mb on the disk. It is running on a mssql server at the moment but I would like to move it over to a postgresql server and postgresql seems to be somewhat fast than