Postgres Pro
Downloads
Home   >   mailing lists

Re: test / live environment, major performance difference - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: test / live environment, major performance difference
Date
Msg-id 20070612145910.GA9034@uio.no
Whole thread Raw
In response to Re: test / live environment, major performance difference  (Christo Du Preez <christo@mecola.com>)
List pgsql-performance
Tree view 
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/

pgsql-performance by date:

Previous
From: Bill Moran
Date:
Subject: Re: How much memory PostgreSQL is going to use?
Next
From: Vladimir Stankovic
Date:
Subject: Re: Variable (degrading) performance