2009/8/19 Grzegorz Jaśkiewicz <gryzman@xxxxxxxxx>
It looks like those extracts just make constant integer times. You probably just create an index on the time column.
Also, why not store times as timestamps?
that seems to be the killer:
You probably need an index on time/epoch:
and time >= extract ('epoch' from timestamp '2009-08-12')
and time < extract ('epoch' from timestamp '2009-08-13' )
CREATE INDEX foo ON table(extract ('epoch' from timestamp time );
It looks like those extracts just make constant integer times. You probably just create an index on the time column.
Also, why not store times as timestamps?
or something like that, vacuum analyze and retry.
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
