Hi All, Just a small comment from a mortal user.
On Thursday 01 June 2006 19:28, Josh Berkus wrote: > 5. random_page_cost (as previously discussed) is actually a funciton of > relatively immutable hardware statistics, and as such should not need to > exist as a GUC once the cost model is fixed. It's correct that the hardware statistics are quite immutable - per tablespace. This suggests to me that the GUC should be default value only and then overridable per tablespace. It's quite normal to have primary (current data) and secondary (historical data) storage for larger databases. This can also fit nicely into the pg_tmp storage if tie support for multiple tmp folders together with tablespaces. > > 6. We haven't added any way to estimate rows returned from SRFs. This would also be very cool - currently the planner can really get annoyed when joining SRF functions with tables. --- Nicolai ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
