>> Also, count(*) is likely to always generate a seq scan due to the way
>> aggregates are implemented currently in pgsql. you might want to try:
By the way, in an ideal world, count(*) should only read the index on the
timetamp column, not the rows. I guess this is not the case. Would this be
an useful optimization ?
