DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	b=mUAQMjqAC61gasgINwEH+A13AeDp6wkpmYxC1n0RzZBQQIAqATTxRFgSV/Y9rlbDEN
	6HPig6/PxmiZ1FQkoeBq8hZvz10Wqd9d68Cl9h96vrEdfdm5+tNQUKkHKRbj+NnDYrMB
	AzGOGbhNRARi8gQrf9Qw0natAtvPUA5wJ78EU=
Message-ID: <4C343A59.7050908@gmail.com>
Date: Wed, 07 Jul 2010 10:27:05 +0200
From: Yeb Havinga <yebhavinga@gmail.com>
User-Agent: Thunderbird 2.0.0.24 (Windows/20100228)
MIME-Version: 1.0
To: "JOUANIN Nicolas (44)" <nicolas.jouanin@dgfip.finances.gouv.fr>
CC: pgsql-performance@postgresql.org
Subject: Re: Two different execution plan for the same request
References: <4C3432F0.1090004@dgfip.finances.gouv.fr>
In-Reply-To: <4C3432F0.1090004@dgfip.finances.gouv.fr>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

JOUANIN Nicolas (44) wrote:
> Hi,
>
> I've trouble with some SQL request which have different execution 
> plans when ran on two different servers. One server is the development 
> environment, the othe rone is th pre-production env.
> Both servers run postgreSQL 8.3.0 on Linux and :
>  - both databases contains the same data (pg_dump/pg_restore between 
> servers)
>  - instances have the same configuration parameters
>  - vaccum and analyze is run every day.
> The only difference I can see is the hardware. The pre-preoduction 
> env. has more RAM, more CPU and a RAID5 disk array through LVM where 
> data are stored.
Hello Jouanin,

Could you give some more information following the guidelines from 
http://wiki.postgresql.org/wiki/SlowQueryQuestions ?

Essential are the contents from both conf files (comments may be removed).

regards,
Yeb Havinga