> On 10 Srpen 2011, 1:17, Ondrej Ivanič wrote: >> - What needs to be changed at Postgres/Operating system level? The >> obvious one is to change random_page_cost (now: 2) and seq_page_cost >> (now: 4). What else should I look at? > > Are you sure about this? I'm not quite sure setting seq_page_cost=4 and > random_page_cost=2 makes sense. Usually seq_page_cost is lower than > random_page_cost, so I wonder why have you set it like that.
Ups! Well spotted Tomas! The actual values are: random_page_cost = 2 seq_page_cost = 1