Strange query plan difference between two machines - Mailing list pgsql-novice

From Ron Arts
Subject Strange query plan difference between two machines
Date
Msg-id 4DFE34F4.7010608@neonova.nl
Whole thread Raw
Responses Re: Strange query plan difference between two machines  (Thom Brown <thom@linux.com>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Compare dates
Next
From: Thom Brown
Date:
Subject: Re: Strange query plan difference between two machines