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
pgsql-novice by date
|Next:||From: Thom Brown||Date: 2011-06-19 18:10:21|
|Subject: Re: Strange query plan difference between two machines|
|Previous:||From: Thomas Kellerer||Date: 2011-06-18 19:10:10|
|Subject: Re: Compare dates|