On Sat, 2005-03-26 at 07:55 -0800, Stephan Szabo wrote: > That seems like it should be okay, hmm, what does something like: > > PREPARE test(int) AS SELECT 1 from measurement where > id_int_sensor_meas_type = $1 FOR UPDATE; > EXPLAIN ANALYZE EXECUTE TEST(1); > > give you as the plan?
QUERY PLAN ----------------------------------------------------------------------------------------------------------------------- Seq Scan on measurement (cost=0.00..164559.16 rows=509478 width=6) (actual time=11608.402..11608.402 rows=0 loops=1) Filter: (id_int_sensor_meas_type = $1) Total runtime: 11608.441 ms (3 rows) -- Karim Nassar Department of Computer Science Box 15600, College of Engineering and Natural Sciences Northern Arizona University, Flagstaff, Arizona 86011 Office: (928) 523-5868 -=- Mobile: (928) 699-9221 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly