Is that an unreasonable value? For the sake of this discussison, I am targeting fairly average bare-metal SSD-backed servers with recent CPUs (let's say 3 year old maximum), with ample available RAM.
if you have SSD, then you can decrease RANDOM_PAGE_COST to 2 maybe 1.5. But probably there will not be impact to this query.
Thanks!
Regards, -- Silvio Moioli SUSE Manager Development Team