Re: query becomes much slower after Postgres 8.2.4 and Postgis 1.2.1 upgrade

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jessica Richard <rjessil(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: query becomes much slower after Postgres 8.2.4 and Postgis 1.2.1 upgrade
Date: 2007-05-16 19:12:12
Message-ID: 6145.1179342732@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Jessica Richard <rjessil(at)yahoo(dot)com> writes:
> After the entire upgrades, a same query with geospatial functions that used to come back in a few minutes, now take about 3 minutes to finish, no erors, just much slower than before.

The standard first question is "did you remember to re-ANALYZE your
tables after reloading into the new database"?

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Keaton Adams 2007-05-16 19:31:32 Re: WAL file utilization question
Previous Message Tom Lane 2007-05-16 17:50:04 Re: ERROR: invalid memory alloc request size