Postgres Pro
Downloads
Home   >   mailing lists

Re: PGSQL 7.4 -> 8.1 migration & performance problem - Mailing list pgsql-general

From Tom Lane
Subject Re: PGSQL 7.4 -> 8.1 migration & performance problem
Date
Msg-id 12183.1149086351@sss.pgh.pa.us
Whole thread Raw
In response to PGSQL 7.4 -> 8.1 migration & performance problem  ("Philippe Lang" <philippe.lang@attiksystem.ch>)
List pgsql-general
Tree view 
"Philippe Lang" <philippe.lang@attiksystem.ch> writes:
> http://www.attiksystem.ch/postgresql-general.txt

Please provide EXPLAIN ANALYZE, not just EXPLAIN, output ... and try to
post it in an un-line-wrapped form.

Also, as Ludwig mentioned, a common gotcha is to forget to ANALYZE your
data after moving it to a new database.

            regards, tom lane

pgsql-general by date:

Previous
From: John DeSoi
Date:
Subject: Re: Lossy character conversion to Latin-1
Next
From: John DeSoi
Date:
Subject: Re: Lossy character conversion to Latin-1