"DANG Trieu" <tdang@xxxxxxxxxxx> writes: > On the "abstract" table (event): > gsmlog3_30=# explain analyze select * from event where timestamp > > 1226952050683 order by timestamp desc limit 10; Turning on constraint exclusion might help here, if you have appropriate check constraints for the range of timestamp attached to all the tables. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
