Re: An "obvious" index not being used

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

Daniele Varrazzo writes:

> I suspect the foo.account_id statistical data are not used at all in query:
> the query planner can only estimate the number of accounts to look for, not

You mentioned you bumped your default_statistics_target.
What did you increase it to?
My data sets are so "strange" that anything less than 350 gives many bad
plans.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Simon Riggs 2008-07-19 09:02:32 Re: Backup/Restore of single table in multi TB database
Previous Message Francisco Reyes 2008-07-19 01:39:55 Re: 3ware vs Areca