Re: index not used with inherited tables

From: Verena Ruff <lists(at)triosolutions(dot)at>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Verena Ruff <lists(at)triosolutions(dot)at>, Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>, pgsql-novice(at)postgresql(dot)org
Subject: Re: index not used with inherited tables
Date: 2006-05-12 14:32:00
Message-ID: 44649C60.2030801@triosolutions.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Robert Landsmeer 2006-05-12 14:45:09 Wondering if anyone could help me
Previous Message Tom Lane 2006-05-12 14:11:53 Re: index not used with inherited tables