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.
In response to
pgsql-performance by date
|Next:||From: Ed Tyrrill||Date: 2007-06-12 01:09:46|
|Subject: Re: Best way to delete unreferenced rows?|
|Previous:||From: Dave Cramer||Date: 2007-06-11 17:59:08|
|Subject: Re: How much ram is too much|