Re: random_page_cost vs seq_page_cost - Mailing list pgsql-hackers

From Benedikt Grundmann
Subject Re: random_page_cost vs seq_page_cost
Date
Msg-id 20120105143427.GG25235@ldn-qws-004.delacy.com
Whole thread Raw
In response to random_page_cost vs seq_page_cost  (Benedikt Grundmann <bgrundmann@janestreet.com>)
List pgsql-hackers
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. 


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: random_page_cost vs seq_page_cost
Next
From: Robert Haas
Date:
Subject: Re: optimizing repeated MVCC snapshots