Does anyone know of any tool that helps in setting the parameters of the file postgresql.conf.
I've already made use of PGTUNE and PGConfig , but they do not indicate anything of the parameters:
- cpu_tuple_cost
- cpu_index_tuple_cost
- cpu_operator_cost
- seq_page_cost
- random_page_cost
I have the problem reported in the other post: Because cost estimates in PostgreSQL are so wrong? , in which the optimizer is always choosing to do full-scan instead of indexed for example. I understand that sometimes it is actually more agile to do full-scan than to leave index, which requires random access, but I have also tested with SSDs, changing random_page_cost = 1, and continued happening the problem (cost incorrect) and indexed strategies, be less efficient than without indices. I think I should adjust these parameters better. If they have any tool tips or other form, please return.