Skip site navigation (1) Skip section navigation (2)

Re: Strange query plan difference between two machines

From: Thom Brown <thom(at)linux(dot)com>
To: Ron Arts <ron(dot)arts(at)neonova(dot)nl>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Strange query plan difference between two machines
Date: 2011-06-19 18:10:21
Message-ID: BANLkTikUNpnvbz48r_o6K6jeE=sJHYA_kQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On 19 June 2011 18:42, Ron Arts <ron(dot)arts(at)neonova(dot)nl> wrote:
> Hi,
>
> I have two machines that have the same database with the same table
> and indexes (definitions are exactly the same). I compared the
> postgresql.conf
> and they are the same.
>
> Still the SQL query plan differs greatly for the same query. VACUUM ANALYZE
> does not make a difference, neither does recreating the indexes.
>
> Any hints on what could cause this? What can I check? How can I
> debug it?

Are the 2 versions of PostgreSQL between the 2 servers identical too?

-- 
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

pgsql-novice by date

Next:From: java4devDate: 2011-06-19 20:21:14
Subject: Re: PL/pgSQL editor/debugger
Previous:From: Ron ArtsDate: 2011-06-19 17:42:12
Subject: Strange query plan difference between two machines

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group