Re: test / live environment, major performance difference

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: Christo Du Preez <christo(at)mecola(dot)com>
Cc: Reid(dot)Thompson(at)ateb(dot)com, pgsql-performance(at)postgresql(dot)org
Subject: Re: test / live environment, major performance difference
Date: 2007-06-12 14:59:10
Message-ID: 20070612145910.GA9034@uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Vladimir Stankovic 2007-06-12 15:24:30 Re: Variable (degrading) performance
Previous Message Bill Moran 2007-06-12 14:37:16 Re: How much memory PostgreSQL is going to use?