q.sql

application/octet-stream

Download

--this has one of the big 22M rows
select count(1) from (select * from dies where date_created::date = '2008-01-21'::date) as foo;
--same with this one
select count(1) from (select * from dies where date_created::date = '2008-01-25'::date) as foo;
-- this one does not
select count(1) from (select * from dies where date_created::date = '2008-01-20'::date) as foo;