Nolan Cafferky <Nolan.Cafferky@xxxxxxxxxxxxxxxxxx> writes: > But, I'm guessing that random_page_cost = 1 is not a realistic value. Well, that depends. If all your data can be expected to fit in memory then it is a realistic value. (If not, you should be real careful not to make performance decisions on the basis of test cases that *do* fit in RAM...) In any case, if I recall your numbers correctly you shouldn't need to drop it nearly that far to get the thing to make the right choice. A lot of people run with random_page_cost set to 2 or so. regards, tom lane
