Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group