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 2B723D1B446 for ; Mon, 22 Dec 2003 22:33:00 +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 96705-06 for ; Mon, 22 Dec 2003 18:32:12 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 5DBDCD1B450 for ; Mon, 22 Dec 2003 18:32:09 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id hBMMWB19018709; Mon, 22 Dec 2003 17:32:11 -0500 (EST) To: Michael Guerin Cc: pgsql-performance@postgresql.org Subject: Re: postgresql performance on linux port In-reply-to: <3FE741FA.4000002@rentec.com> References: <3FE741FA.4000002@rentec.com> Comments: In-reply-to Michael Guerin message dated "Mon, 22 Dec 2003 14:11:54 -0500" Date: Mon, 22 Dec 2003 17:32:11 -0500 Message-ID: <18708.1072132331@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/290 X-Sequence-Number: 5150 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