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
