X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0E7CF53920 for ; Sat, 26 Mar 2005 19:33:00 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 21231-03 for ; Sat, 26 Mar 2005 19:32:59 +0000 (GMT) Received: from mailgate2.nau.edu (mailgate2.nau.edu [134.114.96.59]) by svr1.postgresql.org (Postfix) with ESMTP id DA62B53930 for ; Sat, 26 Mar 2005 19:32:57 +0000 (GMT) Received: from CONVERSION-DAEMON.mailgate2.nau.edu by mailgate2.nau.edu (PMDF V6.2-X17 #30770) id <0IDZ002014YX2P@mailgate2.nau.edu> for pgsql-performance@postgresql.org; Sat, 26 Mar 2005 12:32:58 -0700 (MST) Received: from k2.cet.nau.edu (net9-213.cet.nau.edu [134.114.9.213]) by mailgate2.nau.edu (PMDF V6.2-X17 #30770) with ESMTP id <0IDZ009DK4YXNW@mailgate2.nau.edu>; Sat, 26 Mar 2005 12:32:57 -0700 (MST) Date: Sat, 26 Mar 2005 12:36:28 -0700 From: Karim Nassar Subject: Re: Delete query takes exorbitant amount of time In-reply-to: <20050326075020.P63597@megazone.bigpanda.com> To: Stephan Szabo Cc: Simon Riggs , Tom Lane , Christopher Kings-Lynne , pgsql-performance@postgresql.org Message-id: <1111865788.9172.13.camel@k2.cet.nau.edu> MIME-version: 1.0 X-Mailer: Evolution 2.0.2 Content-type: text/plain Content-transfer-encoding: 7BIT References: <1111709457.9085.127.camel@k2.cet.nau.edu> <2630.1111711927@sss.pgh.pa.us> <1111715131.9085.174.camel@k2.cet.nau.edu> <3750.1111715318@sss.pgh.pa.us> <4243879B.10200@familyhealth.com.au> <20845.1111733900@sss.pgh.pa.us> <1111763448.11750.730.camel@localhost.localdomain> <1111787264.9168.7.camel@k2.cet.nau.edu> <20050326075020.P63597@megazone.bigpanda.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/584 X-Sequence-Number: 11289 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