tags: PostgresQL Recently, I met a problem in PostgresQL: the index mismatched after batch rows inserted. Run ANALYZE on the table solved this problem after batch rows inerted. Turns out autovacuum has been disabled on the PostgresQL instance: show autovacuum_analyze_scale_factor; show autovacuum_analyze_threshold ; SELECT * FROM pg_settings WHERE name LIKE '%autovacuum%';
tags: Database, PostgresQL source: Crunchy Data. “Five Tips For a Healthier Postgres Database in the New Year.” Accessed February 13, 2023. https://crunchydata.com/blog/five-tips-for-a-healthier-postgres-database-in-the-new-year.
tags: PostgresQL, Cheatsheet Create User and Role Docs: Examples of Create Role CREATE ROLE whoami WITH LOGIN PASSWORD 'P@ssw0rd'; Create Database Docs: Examples of Create Database CREATE DATABASE sales OWNER whoami;