On Fri, Apr 17, 2009 at 4:29 AM, Scott Marlowe <[email protected]> wrote: > On Fri, Apr 17, 2009 at 4:17 AM, Scott Marlowe <[email protected]> > wrote: >> On Fri, Apr 17, 2009 at 3:00 AM, Iñigo Martinez Lasala >> <[email protected]> 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.
Try craniking up your default stats setting and running analyze again and seeing if it runs fast even with the index. -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
