X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 89BC2D1B480 for ; Tue, 23 Dec 2003 00:34:31 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 08231-07 for ; Mon, 22 Dec 2003 20:33:44 -0400 (AST) Received: from wren.rentec.com (unknown [65.213.84.9]) by svr1.postgresql.org (Postfix) with ESMTP id F35FDD1B4A3 for ; Mon, 22 Dec 2003 20:33:40 -0400 (AST) Received: from rentec.com (guerinpc.rentec.com [172.16.161.26]) by wren.rentec.com (8.12.1/8.12.1) with ESMTP id hBN0XZ12013021; Mon, 22 Dec 2003 19:33:35 -0500 (EST) Message-ID: <3FE78D61.2F0AECAD@rentec.com> Date: Mon, 22 Dec 2003 19:33:37 -0500 From: Michael Guerin X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 To: Tom Lane Cc: pgsql-performance@postgresql.org Subject: Re: postgresql performance on linux port References: <3FE741FA.4000002@rentec.com> <18708.1072132331@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/294 X-Sequence-Number: 5154 Hi Tom, I don't believe I did run Analyze, I was under the assumption that the statistics would have been up to date when the indexes were created. Thanks for the quick response. -mike Tom Lane wrote: > Michael Guerin writes: > > I just restored a database running on a solaris box to a linux box > > and queries take forever to execute. > > Did you remember to run ANALYZE? Have you applied the same > configuration settings that you were using before? > > regards, tom lane