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

Re: test / live environment, major performance difference

From: Craig James <craig_james(at)emolecules(dot)com>
To:
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: test / live environment, major performance difference
Date: 2007-06-11 18:26:55
Message-ID: 466D93EF.4010300@emolecules.com (view raw or flat)
Thread:
Lists: pgsql-performance
On 2007-06-11 Christo Du Preez wrote:
> I really hope someone can shed some light on my problem. I'm not sure
> if this is a posgres or potgis issue.
>
> Anyway, we have 2 development laptops and one live server, somehow I
> managed to get the same query to perform very well om my laptop, but
> on both the server and the other laptop it's really performing bad.

One simple possibility that bit me in the past: If you do pg_dump/pg_restore to create a copy of the database, you have to ANALYZE the newly-restored database.  I mistakenly assumed that pg_restore would do this, but you have to run ANALYZE explicitely after a restore.

Craig


In response to

Responses

pgsql-performance by date

Next:From: Ed TyrrillDate: 2007-06-12 01:09:46
Subject: Re: Best way to delete unreferenced rows?
Previous:From: Dave CramerDate: 2007-06-11 17:59:08
Subject: Re: How much ram is too much

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