X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A214B3A3E8B for ; Sat, 6 Nov 2004 20:11:54 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 48860-08 for ; Sat, 6 Nov 2004 20:11:35 +0000 (GMT) Received: from main.gmane.org (main.gmane.org [80.91.229.2]) by svr1.postgresql.org (Postfix) with ESMTP id 15CE03A3E19 for ; Sat, 6 Nov 2004 20:11:37 +0000 (GMT) Received: from root by main.gmane.org with local (Exim 3.35 #1 (Debian)) id 1CQWuO-0007PU-00 for ; Sat, 06 Nov 2004 21:11:36 +0100 Received: from 62.79.119.132.adsl.vbr.tiscali.dk ([62.79.119.132]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 06 Nov 2004 21:11:36 +0100 Received: from troels by 62.79.119.132.adsl.vbr.tiscali.dk with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 06 Nov 2004 21:11:36 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: Troels Arvin Subject: Re: poor performance in migrated database Date: Sat, 06 Nov 2004 21:07:06 +0100 Lines: 26 Message-ID: References: <20041106195215.91282.qmail@web52706.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: 62.79.119.132.adsl.vbr.tiscali.dk User-Agent: Pan/0.14.2.91 (As She Crawled Across the Table) Cc: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/48 X-Sequence-Number: 15433 On Sat, 06 Nov 2004 11:52:15 -0800, Carlos Lopez wrote: > I have migrated a database from MS SQL to a > postgresSQL database, but when running it, the results > are very slow (and unusable) which is the only reason > we don't entirely move to postgresSQL. Have you run ANALYZE lately? (See manual.) Do you know how to use EXPLAIN? (See manual.) If so: Please post an example query which is slow, and the corresponding output from EXPLAIN. Have you tried turning your random_page_cost a bit down? (My experience its value should generally be lessened.) Have you read http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html ? > The biggest table has about 300k records (isn't it too > little for having performance problems?) That should be no problem. -- Greetings from Troels Arvin, Copenhagen, Denmark