Re: Statistics Injection

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(dot)vladimir(at)gmail(dot)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

LinkedIn:
http://gr.linkedin.com/pub/victor-giannakouris-salalidis/69/585/b23/
Personal Page: http://gsvic.github.io