Tom Lane wrote:
I don't think any test that we could build would be as useful as simply trying the different settings with an installation's real workload.
Benchmarking the real workload isn't always so easy, and might be quite time consuming to obtain meaningful values. Don't you think that some test app doing heavy inserts (maybe with multiple processes) would be sufficient to decide which option is best on that particular machine?
Regards, Andreas
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
