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_statsVladimir
Victor Giannakouris - Salalidis
Researcher
Computing Systems Laboratory (CSLab),
National Technical University of Athens
Personal Page: http://gsvic.github.io
В списке pgsql-hackers по дате отправления: