Re: [HACKERS] 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.vladi...@gmail.com> wrote: > > > > The problem is that, even if I set the reltuples and relpages of my > choice, when I

Re: [HACKERS] Statistics Injection

> 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

Re: [HACKERS] Statistics Injection

Victor Giannakouris - Salalidis writes: > For some research purposes, I am trying to modify the existing statistics > of some tables in the catalogs in order to change the execution plan, > experiment with the EXPLAIN call etc. > Concretely, what I'd like to do is to create

[HACKERS] Statistics Injection

Hello, For some research purposes, I am trying to modify the existing statistics of some tables in the catalogs in order to change the execution plan, experiment with the EXPLAIN call etc. Concretely, what I'd like to do is to create a "fake" table with a schema of my choice (that's the easy