FYFIRMAN Long Living NotesAboutAboutContact ↗Contact ↗ (opens in a new tab)
GitHubGitHub (opens in a new tab) (opens in a new tab)
  • Introduction
      • Weird Function Class
      • Curated Eslint Problem
      • How to Write React Props
      • Non Reserved Enum Problem
      • TypeScript Assigning Key to Window
      • TypeScript Narrowing Problem
      • TypeScript Nightmare No Index Signature
      • TypeScript Red Problem
      • Jest Frontend
      • Zustand Test
    • Zod
    • Caching in Frontend with React Query
    • Design Mode
    • Frontend Utility Tools
    • Thundering Herd Problem
      • Animation Reference
      • Object Collision
      • Server Action
      • Curated Problem
      • Cleaner Output in Npm
      • How to Free up the Memory
      • Nestjs Snippets
      • Nestjs Testing
        • Class Validator Snippets
      • Curated Golang Library
      • Golang Beginner Snippets
      • Golang Learning Resource
      • Golang Snippets Print Any Json Request Response
      • Golang Unit Test
      • How to Structure Your Project in Golang
      • Venv
      • 1 on 1 Relationship Vs Single Table
      • Aurora Query Plan Management
      • Database Scaling Cheat Sheet
      • Find Optimal Indexing
      • Kill Existing Processes or Transactions
      • Optimizing Query Postgresql
      • Pages in Postgresql
      • Postgre SQL Constraint Checking Behavior Deferred or Immediate
      • Postgresql Dump Snippets
      • Tuning Postgresql
      • Useful Information Schema Query
      • Why Indexing Can Make Db Faster
    • Authorization Models
    • Backend Roadmap
    • Dbeaver Show Password
    • How to Build Your Own Auth
    • Sqlite
    • Uuid Version
      • Mysql Dump Snippets
      • Install Composer
      • PHP Issue
      • PHP Snippet
      • Most Popular Libraries in Rust
      • System Design Resource
      • Twitter System Design
    • Alternative Infrastructure Tools
    • API Testing with Hey
    • How to Create HTTPS in Docker Env
    • How to Monitor Memory Usage of Ec2
    • Netdata
    • Observability White Paper
    • Portainer
    • Setup Certbot in Docker
    • Termux
    • Tunneling
    • Watchtower
      • Aws Rds
      • Docker Snippets
      • Logql Snippet Collection
    • Exclude File in Git without Gitignore
    • Git Snippet
    • Rewriting Git Author
    • Cto Vp Hoe Difference
    • Currated Scalability Blog
    • Engineering Career Levels
    • How to Get Promotions
    • Mac Configuration
    • Mac Shortcut
    • Most Useful Apps on macOS
    • Toggle Fn on Mac
    • Binary Search Approach
    • Books Wishlist
    • Chrome Shortcut
    • Code for Kids
    • Curated Open Source Tools
    • Exploring Screenshot to Code
    • Google Sheets API
    • I Dont Know yet List
    • Investigating Disk Full
    • Password Protection Website
    • Terminal Tooling to Improve Productivity
    • Vim Cheatsheet
    • Vscode Extention
    • Vscode Shortcut
    • Autobahn Bookmark
    • Autobahn Frontend Snippets
    • Things I Should Do When Migrate Fy Infra
    • Ads Software
    • Business Terms
    • Business Things That I Need to Know
    • Leadership Tools or Framework
    • Naming Variables
    • Refactoring Code
Feedback? Reach out me in X (opens in a new tab)
🤖 Backend
PostgreSQL
Tuning Postgresql

https://www.enterprisedb.com/postgres-tutorials/how-tune-postgresql-memory (opens in a new tab)

https://andreigridnev.com/blog/2016-04-16-increase-work_mem-parameter-in-postgresql-to-make-expensive-queries-faster/ (opens in a new tab)

Config your postgresql https://postgresqlco.nf/ (opens in a new tab)

Postgresql Dump SnippetsUseful Information Schema Query
Firmansyah Yanuar