11.8. Partial Indexes # A partial index is an index built over a subset of a table; the subset is defined …| PostgreSQL Documentation
20.7. Query Planning # 20.7.1. Planner Method Configuration 20.7.2. Planner Cost Constants 20.7.3. Genetic Query Optimizer 20.7.4. Other Planner Options 20.7.1. Planner …| PostgreSQL Documentation
At work I was tasked to migrate our time-series analytics data from CSV file dumps that we’ve been feeding into Power BI to a dedicated database. Our Rails app’s primary database is currently MariaDB, but we wanted to have our analytics data in a separate database either way, so this was a good opportunity to use Postgres which we’re most comfortable with anyway.| Janko Marohnić
ALTER TABLE ALTER TABLE — change the definition of a table Synopsis ALTER TABLE [ IF EXISTS ] [ ONLY …| PostgreSQL Documentation