Optimization of SQL requests
With the size of the databse constantly increasing, routines uch as database.select()
starts to take a long time. It would be nice to optimize SQL requests. Relevant documents:
Lupa use many SQL requests and it is not obvious to find out which ones take time. A first step would be to identify the requests really worthy of optimization work. May be enabling log_min_duration_statement
and log_duration
to pinpoint them. May be also debug_print_plan
.