Re: [PERFORM] Query in 9.0.2 not using index in 9.0.0 works fine

2011-07-06 Thread Matthias Howell
From: Samuel Gendler [mailto:sgend...@ideasculptor.com] Sent: Wednesday, July 06, 2011 3:43 AM To: Matthias Howell Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Query in 9.0.2 not using index in 9.0.0 works fine On Tue, Jul 5, 2011 at 1:50 PM, Matthias Howell wrote

[PERFORM] Query in 9.0.2 not using index in 9.0.0 works fine

2011-07-06 Thread Matthias Howell
I've just copied a database from one linux machine to another. "Fast" machine is CentOS 5.5, running postgres 9.0.0 64 bit "Slow" machine is Red Hat 5.5 running postgres 9.0.2 64 bit. Here's the query: explain analyze select sentenceid from sentences where sentenceid = any ( array(select