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 |
<div style="width: 100%; font-size: initial; color: rgb(31, 73, 125); text-align: initial; background-color: rgb(255, 255,255);"><span style="font-family: Calibri, 'Slate Pro', sans-serif, sans-serif;"><br /></span></div><div style="width:100%; font-size: initial; color: rgb(31, 73, 125); text-align: initial; background-color: rgb(255, 255, 255);"><br/></div><div style="font-family: sans-serif; font-size: 12.8px;">> The problem is that, even if I set the reltuplesand 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.</div><div style="font-family: sans-serif; font-size:12.8px;"><br /></div><div style="font-family: sans-serif; font-size: 12.8px;">>Could anyone help me with that?</div><divstyle="width: 100%; font-size: initial; color: rgb(31, 73, 125); text-align: initial; background-color: rgb(255,255, 255);"><span style="font-family: Calibri, 'Slate Pro', sans-serif, sans-serif;"><br /></span></div><div style="width:100%; font-size: initial; color: rgb(31, 73, 125); text-align: initial; background-color: rgb(255, 255, 255);"><spanstyle="font-family: Calibri, 'Slate Pro', sans-serif, sans-serif;"><br /></span></div><div style="width: 100%;font-size: initial; color: rgb(31, 73, 125); text-align: initial; background-color: rgb(255, 255, 255);"><span style="font-family:Calibri, 'Slate Pro', sans-serif, sans-serif;">There's a pg_dbms_stats extension that enables you to override/freezethe statistics: https://github.com/ossc-db/pg_dbms_stats</span></div><div style="width: 100%; font-size: initial;color: rgb(31, 73, 125); text-align: initial; background-color: rgb(255, 255, 255);"><span style="font-family: Calibri,'Slate Pro', sans-serif, sans-serif;"><br /></span></div><div style="width: 100%; font-size: initial; color: rgb(31,73, 125); text-align: initial; background-color: rgb(255, 255, 255);"><span style="font-family: Calibri, 'Slate Pro',sans-serif, sans-serif;">Vladimir</span></div>
В списке pgsql-hackers по дате отправления: