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
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