Re: An "obvious" index not being used

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Daniele Varrazzo <piro(at)develer(dot)com>
Cc: Francisco Reyes <lists(at)stringsutils(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: An "obvious" index not being used
Date: 2008-07-20 04:44:47
Message-ID: 24818.1216529087@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Daniele Varrazzo <piro(at)develer(dot)com> writes:
> In my problem I had 2 tables: a small one (accounts), a large one (foo). The
> way the query is written doesn't allow the stats from the large table to be
> used at all, unless the records from the small table are fetched. This is
> independent from the stats accuracy.

> What the planner does is to assume an even distribution in the data in the
> joined fields.

Sir, you don't know what you're talking about.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Daniele Varrazzo 2008-07-20 23:07:04 Re: An "obvious" index not being used
Previous Message Daniele Varrazzo 2008-07-19 17:21:43 Re: An "obvious" index not being used