Re: random_page_cost vs seq_page_cost

On 05/01/12 10:04, Benedikt Grundmann wrote:
> 
> As a counter measure we are experimenting with 
> enable_nestloop = off
> random_page_cost = 20 (instead of the previous 4).
> 
For what it is worth we had to revert the enable_nestloop = off 
change.  It just moved the pain around by making other queries
perform much worse than before.