PostgreSQL

• The Unexpected Find That Freed 20GB of Unused Index Space.
• Cleaning Up Your Postgres Database.
• PostgreSQL: ANALYZE and optimizer statistics.
• Speeding up GROUP BY in PostgreSQL. This contains two very specific tips for PostgreSQL that I didn’t know and that I want to remember:
  • In a multiple GROUP BY, place first those attributes with more different values.
  • If you’re getting too many GROUP AGGREGATE in your plan, try increasing WORK_MEM so you get HASH AGGREGATE.
• Query Optimization in Postgres with pg_stat_statements.
• Faster data migrations in Postgres.
• Postgres regex search over 10,000 GitHub repositories (using only a Macbook).
• Fuzzy Name Matching in Postgres.
• In Pursuit of PostgreSQL Performance .

Feature flags

• Fowler on FeatureToggle.
• Flipper gem.
  • Gates.
  • ActiveRecord adapter.

Forms in React

• Taming Forms in React.
• Formik.
  • Working example of checkboxes generated from an array.

Misc

• Remove untracked files: git clean -n -d, git clean -f.
• ¿Qué es un manager?.
• Clickhouse tips.