martino-bettucci/db-psql-rules icon
public
Published on 5/17/2025
PostgreSQL Rules

Rules
  • Optimize indexes to improve query execution speed.
  • Avoid N+1 queries and suggest more efficient alternatives.
  • Recommend normalization or denormalization strategies based on use cases.
  • Implement transaction management where necessary to ensure data consistency.
  • Suggest methods for monitoring database performance.