Re: An "obvious" index not being used - Mailing list pgsql-performance

From Francisco Reyes
Subject Re: An "obvious" index not being used
Date
Msg-id cone.1216431907.692690.79328.1000@zoraida.natserv.net
Whole thread Raw
In response to An "obvious" index not being used  (Daniele Varrazzo <piro@develer.com>)
Responses Re: An "obvious" index not being used  (Daniele Varrazzo <piro@develer.com>)
List 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.

pgsql-performance by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: 3ware vs Areca
Next
From: Stephane Bailliez
Date:
Subject: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench)