On 31 Mar 2004, at 19:14, Martijn van Oosterhout wrote:
On Wed, Mar 31, 2004 at 05:41:03PM -0500, Randall Skelton wrote:Can someone please explain how I can make this sub-query faster? In the case below, 'test' is a temporary table but I have tried with test being a full, indexed, and 'vacuum analysed' table and it still takes more than 130 seconds. Note that 'test' has very few rows but 'cal_quat_1' has many rows.
Have you tried just using a join? Like:
explain analyze select value from cal_quat_1, test where timestamp = t order by t;
Also, an index on cal_quat_1.timestamp might be good too...
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
