Re: Statistics Injection

Поиск
Список
Период
Сортировка
От Victor Giannakouris - Salalidis
Тема Re: Statistics Injection
Дата
Msg-id CALUSaSpUz6962i0Dob66k_Q=58wcYvKiWxORLG0ay_cG=-KUmA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Statistics Injection  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
Список pgsql-hackers
Hello,

pg_dbms_stats worked well for my case, thank you all for your quick responses and for the support!

Victor

On Sat, Jul 2, 2016 at 8:28 PM, Vladimir Sitnikov <sitnikov.vladimir@gmail.com> wrote:


> 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



--
Victor Giannakouris - Salalidis

Researcher
Computing Systems Laboratory (CSLab),
National Technical University of Athens

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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Reviewing freeze map code
Следующее
От: Vladimir Borodin
Дата:
Сообщение: Re: [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6