Без рубрики

here how excess indexes can be found, excess mean that there is a single column index which is covered by first value of complex index

base took from ASH Architecture and Advanced Usage — RMOUG

first of all we need to create directory for config files outside $PGDATA: in my case this is /u01/postgres/9.5/main/conf/ next we need to modify service and add option with path of postgresql.conf in config file we modify location of other config files:

Original from Paul Ramsey Hi all, because English is not my native language, that’s why I will write as little as possible =) here is the case, when we write a query with like and get Seq Scan (full table scan), instead index scan this material can be usefull for you if we create same … Читать далее

try to make table partitioned: create dummy table: start redef and get error: this is because original table have a timestamp with local timezone format how to fix it:

original

Trying to find out overhead of new Adaptive Query Optimization feature use perf to find out process cpu usage ( eg:perf stat -e task-clock -p 9576 sleep 5 ) to disable adaptive features I used so the result is: 3000 hpares 3000 hpares 3000 hpares 3000 hpares 3000 hpares avg adaptive off 1724,46 1786,04 1696,22 … Читать далее