Re: [PERFORM] indexes ignored when querying the master table

2011-05-10 Thread Thomas Hägi
hi florian sorry for the late reply - it took almost a day to dump & reload the data into 9.1b1. how can i get postgres to use the indexes when querying the master table? I believe that this is a new feature in PostgreSQL 9.1 ("Allow inheritance table queries to return meaningfully-sorted r

[PERFORM] indexes ignored when querying the master table

2011-05-08 Thread Thomas Hägi
i have around 25mio records of data distributed yearly over 9 child tables (data.logs_20xx) that inherit from the master table data.logs. the tables are partitioned using the field "re_timestamp", which has btree indexes defined on all tables. the query "SELECT * FROM data.logs ORDER BY re_tim