Skip site navigation (1) Skip section navigation (2)

Re: test / live environment, major performance difference

From: Alvaro Herrera <alvherre(at)commandprompt(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:24:38
Message-ID: 20070612142438.GB6748@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-performance
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"

In response to

pgsql-performance by date

Next:From: ArnauDate: 2007-06-12 14:27:39
Subject: How much memory PostgreSQL is going to use?
Previous:From: Christo Du PreezDate: 2007-06-12 14:11:33
Subject: Re: test / live environment, major performance difference

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group