On Wed, Feb 18, 2004 at 11:58:24AM -0500, Randall Skelton wrote: > Greetings all, > > I am trying to do what should be a simple join but the tables are very > large and it is taking a long, long time. I have the feeling that I > have stuffed up something in the syntax. > > Here is what I have: > > telemetry=> select (tq1.timestamp = tq2.timestamp) as timestamp, > tq1.value as q1, tq2.value as q2 from cal_quat_1 tq1 inner join > cal_quat_2 as tq2 using (timestamp) where timestamp > '2004-01-12 > 09:47:56.0000 +0' and timestamp < '2004-01-12 09:50:44.7187 +0' order > by timestamp;
Please run ANALYZE and then send the EXPLAIN ANALYZE <query> output. -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > If the Catholic church can survive the printing press, science fiction > will certainly weather the advent of bookwarez. > http://craphound.com/ebooksneitherenorbooks.txt - Cory Doctorow
pgp00000.pgp
Description: PGP signature
