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... -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > This space intentionally left blank
Attachment:
pgp00178.pgp
Description: PGP signature
