Received: from ant.utdt ([200.41.62.131]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA28113 for ; Thu, 18 May 2000 16:33:31 -0400 (EDT) (envelope-from mig@utdt.edu) From: mig@utdt.edu Received: (from mig@localhost) by ant.utdt (8.8.7/8.8.7) id RAA05089; Thu, 18 May 2000 17:27:42 -0300 Date: Thu, 18 May 2000 17:27:42 -0300 Message-Id: <200005182027.RAA05089@ant.utdt> X-Authentication-Warning: ant.utdt: mig set sender to mig@utdt.edu using -f To: klcollins@wsicorp.com CC: pgsql-sql@postgresql.org In-reply-to: <39245036.71D4618F@wsicorp.com> (message from Kate Collins on Thu, 18 May 2000 16:19:02 -0400) Subject: Re: SQL command speed References: <3924405E.15014E6B@wsicorp.com> <200005181938.QAA04835@ant.utdt> <39245036.71D4618F@wsicorp.com> X-Archive-Number: 200005/67 Thanks for your reply; I am disappointed that it did not work the way I thought it would ... I suppose that you did VACUUM ANALYZE your table recently, right? If not, the stale table statistics may be playing a role too: do it, and try again. With this I have reached the outer boundaries of my "knowledge"; if it doesn't work out, I hope somebody else may be able to help. In any case, I would appreciate knowing more about your tests and the eventual outcome ... Miguel