4 ms·

Is there a Postgres equivalent to reoptimize prepared statements?

• quizotic 10y ago
  I think you can just prepare them again, no? Of course the onus is then on poor you to know when that might make sense because of changes to the referenced tables. Though postgres is so incredibly open, you could probably do that with a trigger or a hook into analyze or vacuum or copy-from.
  • anarazel 10y ago
    Prepared statements are re-planned on use if the underlying statistics change.
    • quizotic 10y ago
      Ah. Thank you for the correction!