From: | Daniel Mahler <mahler(at)cyc(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Optimizer/Planner levels |
Date: | 2003-06-24 20:34:45 |
Message-ID: | 16120.46565.701784.293815@kong.cyc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I was wondering if there is a way the set levels,
or otherwize influence the behaviour of the optimizer.
In the near future I will need to do some very large joins
of very large tables.
I have reason to believe that the final resul will be manageable,
but I do not have definite information about the optimal join order.
Without very aggressive optimization,
it is likely the intermediate results will swamp the system.
I would be willing to spend minutes, even hours, in the optyimizer
for the sake of getting a feasible query plan.
Is there a way to tell the optimizer to just do whatever it takes.
Also is there a way to give it partial heuristic advice
on constructing the query.
thanks
Daniel
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2003-06-24 20:53:20 | Re: capturing and storing query statement with rules |
Previous Message | Andrew Gould | 2003-06-24 20:25:07 | pg_dumping schemes (not schema) |