On Fri, Apr 17, 2009 at 4:17 AM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > On Fri, Apr 17, 2009 at 3:00 AM, Iñigo Martinez Lasala > <imartinez@xxxxxxxxxxxx> wrote: >> Hi everybody again. >> >> Deleting rel_dis_can_fk index has solved the problem! But.... why?? > > Hard to say without explain analyze output. > I'd hazard a guess that you're getting a lot more rows back from the bitmap scan of rel_dis_can_fk than the query planner expects. But that's just a guess. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
