On 19 June 2011 18:42, Ron Arts <ron(dot)arts(at)neonova(dot)nl> wrote:
> I have two machines that have the same database with the same table
> and indexes (definitions are exactly the same). I compared the
> 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?
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: java4dev||Date: 2011-06-19 20:21:14|
|Subject: Re: PL/pgSQL editor/debugger|
|Previous:||From: Ron Arts||Date: 2011-06-19 17:42:12|
|Subject: Strange query plan difference between two machines|