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.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 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
