Comment 3 for bug 1469758

This is what I get when I run that query on our DB: http://pastie.org/10266548

One difference I see between mine and csharp's right away is that he has "Seq Scan on copy acp" while I have "Index Scan using copy_pkey on copy acp". That alone takes up considerable time on his system as it polls through 11+ million items. There may be other cases where the query plan isn't using the indexes right.