** This report needs more confirmation through a proper test setup. **
Prosody can create more prepared statements than strictly necessary for some kinds of queries, which can lead to unnecessary resource consumption (i.e. garbage collecting idle prepared statements that could be reused).
0.10 has improved a number of SQL-related things, and I feel strongly that this fix should also go into the release, or at least some testing to assess the real-world impact.