System performance lead @ Postgres Professional;
ex-Netcracker;
FreeBSD committer (bugfixing);
-
PostgresPro
- Moscow
Pinned Loading
-
Ansible playbook for MaxPerformance
Ansible playbook for MaxPerformance 1- name: tune operating system
2hosts: all
3become: true
4vars:
5sysctl_settings:
-
PostgreSQL may ignore index
PostgreSQL may ignore index 1PostgreSQL (12-16) may ignore your fresh built index due to long-running transaction in another session. It's since 2007, introduced by HOT optimization. Look at pg_index.indcheckxmin of your index.
23First session:
4```
5postgres=# begin;
-
-
Something went wrong, please refresh the page to try again.
If the problem persists, check the GitHub status page or contact support.
If the problem persists, check the GitHub status page or contact support.