Josh Berkus <josh@agliodbs.com> writes: >> I would like something that really measures values like random_page_cost >> or cpu_tuple_cost that are hardware dependent. >> >> I assume such thing does not exist?
> Nope. You gotta whip out your calculator and run some queries. Preferably a whole lot of queries. All the measurement techniques I can think of are going to have a great deal of noise, so you shouldn't twiddle these cost settings based on just a few examples. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster