Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 01D739FA4B9 for ; Tue, 9 Jan 2007 11:13:34 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 08923-03 for ; Tue, 9 Jan 2007 11:13:26 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 043719FA432 for ; Tue, 9 Jan 2007 11:13:26 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l09FD4CW007473; Tue, 9 Jan 2007 10:13:04 -0500 (EST) To: "Gregory S. Williamson" cc: db@zigo.dhs.org, pgsql-performance@postgresql.org Subject: Re: Horribly slow query/ sequential scan In-reply-to: <71E37EF6B7DCC1499CEA0316A256832802B3EB8C@loki.wc.globexplorer.net> References: <71E37EF6B7DCC1499CEA0316A256832802B3EB8A@loki.wc.globexplorer.net> <37813.192.121.104.48.1168346136.squirrel@zigo.dhs.org> <71E37EF6B7DCC1499CEA0316A256832802B3EB8C@loki.wc.globexplorer.net> Comments: In-reply-to "Gregory S. Williamson" message dated "Tue, 09 Jan 2007 04:56:43 -0800" Date: Tue, 09 Jan 2007 10:13:04 -0500 Message-ID: <7472.1168355584@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/114 X-Sequence-Number: 22715 "Gregory S. Williamson" writes: > HAving burdened others with my foolishness too often, I hesitate to > ask, but could someone either point me to a reference or explain what > the difference might be ... I can see it with the eyes but I am having > trouble understanding what Informix might have been doing to my (bad > ?) SQL to "fix" the query. Me too. Does informix have anything EXPLAIN-like to show what it's doing? regards, tom lane