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