Thread: Strange query plan difference between two machines

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?

Thanks,
Ron

On 19 June 2011 18:42, Ron Arts <ron.arts@neonova.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