Hi, what is the size of the table and index (in terms of pages and
tuples)? Try something like
SELECT relpages, reltuples FROM pg_class WHERE relname = 'table or index
name';
And what indexes have you created? It seems to me there's just index on
the variable_id. It might be useful to create inde
Hello everybody,
having this SQL query:
--
select
variable_id,float_value,ts,good_through,interval,datetime_value,string_value,int_value,blob_value,history_value_type
from "records_437954e9-e048-43de-bde3-057658966a9f" where variable_id
in (22727) and (ts >= '2010-10-02 11:19:55' or g