[PERFORM] Low disk performance?

2010-11-18 Thread Martin Chlupac
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

[PERFORM] Data caching

2009-07-09 Thread Martin Chlupac
Hello everybody, I have a simple query which selects data from not very large table ( 434161 rows) and takes far more time than I'd expect. I believe it's due to a poor disk performance because when I execute the very same query for a second time I get much better results (caching kicks in?). Can