Re: index not used with inherited tables - Mailing list pgsql-novice

From Verena Ruff
Subject Re: index not used with inherited tables
Date
Msg-id 44649C60.2030801@triosolutions.at
Whole thread Raw
In response to Re: index not used with inherited tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Hi,

Tom Lane schrieb:
> Yes, and I'm sure it did.  The more relevant question is how much data
> do you have in the child table?  The planner generally won't bother with
> an indexscan if the table is only one or two disk pages; trying to use
> the index in such cases would end up fetching *more* disk pages overall.
>
Yes, there isn't much data in those child tables. It seems like this is
the reason why. Thanks for this information!

Regards,
Verena

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: index not used with inherited tables
Next
From: "Robert Landsmeer"
Date:
Subject: Wondering if anyone could help me