On Wed, Jul 6, 2011 at 5:50 AM, Matthias Howell
wrote:
>
>
> However, in the end, it was user brain damage.
>
> ** **
>
> It does use the doc id index for the subquery, but for some reason, the
> primary key on sentences - the sentenceid - was not set. So in fact, there
> is no index.
>
>
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
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 q
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
