Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id A65859FA458 for ; Tue, 12 Jun 2007 11:59:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 34003-02 for ; Tue, 12 Jun 2007 11:59:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from cassarossa.samfundet.no (cassarossa.samfundet.no [129.241.93.19]) by postgresql.org (Postfix) with ESMTP id 590B59FA371 for ; Tue, 12 Jun 2007 11:59:16 -0300 (ADT) Received: from trofast.sesse.net ([129.241.93.32]) by cassarossa.samfundet.no with esmtp (Exim 4.50) id 1Hy7pu-0007Lj-Q6; Tue, 12 Jun 2007 16:59:11 +0200 Received: from sesse by trofast.sesse.net with local (Exim 3.36 #1 (Debian)) id 1Hy7pu-0002Mx-00; Tue, 12 Jun 2007 16:59:10 +0200 Date: Tue, 12 Jun 2007 16:59:10 +0200 From: "Steinar H. Gunderson" To: Christo Du Preez Cc: Reid.Thompson@ateb.com, pgsql-performance@postgresql.org Subject: Re: test / live environment, major performance difference Message-ID: <20070612145910.GA9034@uio.no> Mail-Followup-To: Christo Du Preez , Reid.Thompson@ateb.com, pgsql-performance@postgresql.org References: <466EA078.20601@mecola.com> <1181655920.19256.3.camel@jhereg> <466EA995.7020106@mecola.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <466EA995.7020106@mecola.com> X-Operating-System: Linux 2.6.20.4 on a x86_64 X-Message-Flag: Outlook? --> http://www.mozilla.org/products/thunderbird/ User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/211 X-Sequence-Number: 25244 On Tue, Jun 12, 2007 at 04:11:33PM +0200, Christo Du Preez wrote: > The actual table I noticed the problem has a million rows and it still > doesn't use indexing Then please post an EXPLAIN ANALYZE of the query that is slow, along with the table definition and indexes. /* Steinar */ -- Homepage: http://www.sesse.net/