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 r
> 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
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 a "fake" table with a
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 part