Re: Statistics Injection

Поиск
Список
Период
Сортировка
От Vladimir Sitnikov
Тема Re: Statistics Injection
Дата
Msg-id 20160702172807.5926993.59010.18340@gmail.com
обсуждение
Ответ на Statistics Injection  (Victor Giannakouris - Salalidis <victorasgs@gmail.com>)
Ответы Re: Statistics Injection
Список pgsql-hackers


> The problem is that, even if I set the reltuples and relpages of my choice, when I run the EXPLAIN clause for a query in which the 'newTable'  is involved in (e.g. EXPLAIN SELECT * FROM newTable), I get the same cost and row estimation.

>Could anyone help me with that?


There's a pg_dbms_stats extension that enables you to override/freeze the statistics: https://github.com/ossc-db/pg_dbms_stats

Vladimir

В списке pgsql-hackers по дате отправления: