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


On Sat, Jul 2, 2016 at 8:28 PM, Vladimir Sitnikov <
sitnikov.vladi...@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

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

Personal Page: http://gsvic.github.io

Reply via email to