Re: [PERFORM] Inoptimal query plan for max() and multicolumn index

2011-06-21 Thread Vladimir Kulev
mestamp) from sms where number = '5802693'), >  (select max(timestamp) from sms where number = '5801981')); -- Vladimir Kulev Mobile: +7 (921) 555-44-22 Jabber: m...@lightoze.net Skype: lightoze -- Sent via pgsql-performance mailing list (pgsql-performance@postg

[PERFORM] Inoptimal query plan for max() and multicolumn index

2011-06-19 Thread Vladimir Kulev
nd: ((number)::text = '5801981'::text) Total runtime: 853.176 ms According to planner cost estimations - it has enough data to understand that it is better to aggregate maximum from three subqueries. I suppose it's not a bug but not implemented feature - maybe there is already som