> 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
|
- [HACKERS] Statistics Injection Victor Giannakouris - Salalidis
- Re: [HACKERS] Statistics Injection Tom Lane
- Re: [HACKERS] Statistics Injection Vladimir Sitnikov
- Re: [HACKERS] Statistics Injectio... Victor Giannakouris - Salalidis