Search Postgresql Archives

Re: PGSQL 7.4 -> 8.1 migration & performance problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Philippe Lang" <philippe.lang@xxxxxxxxxxxxxx>
Subject: Re: PGSQL 7.4 -> 8.1 migration & performance problem
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Wed, 31 May 2006 10:39:11 -0400
Cc: pgsql-general@xxxxxxxxxxxxxx
Comments: In-reply-to "Philippe Lang" <philippe.lang@xxxxxxxxxxxxxx> message dated "Wed, 31 May 2006 14:23:59 +0200"
In-reply-to: <6C0CF58A187DA5479245E0830AF84F421D0D46@xxxxxxxxxxxxxxxxxxxxxxxx>
References: <6C0CF58A187DA5479245E0830AF84F421D0D46@xxxxxxxxxxxxxxxxxxxxxxxx>

"Philippe Lang" <philippe.lang@xxxxxxxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- PGSQL 7.4 -> 8.1 migration & performance problem
  - From: Philippe Lang

Prev by Date: Re: Lossy character conversion to Latin-1
Next by Date: Re: Lossy character conversion to Latin-1
Previous by thread: Re: PGSQL 7.4 -> 8.1 migration & performance problem
Next by thread: Re: PGSQL 7.4 -> 8.1 migration & performance problem
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux