Postgres Pro
Downloads
Home   >   mailing lists

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

From Alvaro Herrera
Subject Re: test / live environment, major performance difference
Date
Msg-id 20070612142438.GB6748@alvh.no-ip.org
Whole thread Raw
In response to Re: test / live environment, major performance difference  (Christo Du Preez <christo@mecola.com>)
List pgsql-performance
Tree view 
Christo Du Preez wrote:
> The actual table I noticed the problem has a million rows and it still
> doesn't use indexing

So ANALYZE it.

--
Alvaro Herrera                          Developer, http://www.PostgreSQL.org/
"Amanece.                                               (Ignacio Reyes)
 El Cerro San Cristóbal me mira, cínicamente, con ojos de virgen"

pgsql-performance by date:

Previous
From: Christo Du Preez
Date:
Subject: Re: test / live environment, major performance difference
Next
From: Arnau
Date:
Subject: How much memory PostgreSQL is going to use?