Received: from www2.intellicast.com ([208.194.150.24]) by hub.org (8.9.3/8.9.3) with SMTP id QAA56362 for ; Thu, 18 May 2000 16:47:40 -0400 (EDT) (envelope-from klcollins@wsicorp.com) Received: from wsicorp.com (ravens.wsicorp.com [147.81.80.26]) by www2.intellicast.com (950413.SGI.8.6.12/950213.SGI.AUTOCF) via ESMTP id QAA08000; Thu, 18 May 2000 16:46:57 -0400 Message-ID: <392456C1.2B5E90D6@wsicorp.com> Date: Thu, 18 May 2000 16:46:57 -0400 From: Kate Collins Organization: Weather Services International X-Mailer: Mozilla 4.72 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: mig@utdt.edu CC: pgsql-sql@postgresql.org Subject: Re: SQL command speed References: <3924405E.15014E6B@wsicorp.com> <200005181938.QAA04835@ant.utdt> <39245036.71D4618F@wsicorp.com> <200005182027.RAA05089@ant.utdt> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200005/69 Miguel, I have re-run VACUUM ANALYZE. Unfortunately, it did not result in a speed up. Thank you for your suggestions and input. They have helped increase my understanding of how it works. I will wait and see if any body else can provide any suggestions or insight. Kate mig@utdt.edu wrote: > 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 -- ================================================= Katherine (Kate) L. Collins Senior Software Engineer/Meteorologist Weather Services International (WSI Corporation) 4 Federal Street Billerica, MA 01821 EMAIL: klcollins@wsicorp.com PHONE: (978) 670-5110 FAX: (978) 670-5100 http://www.intellicast.com