On Wed, Oct 23, 2002 at 18:04:01 +0200, Hans-Jürgen Schönig <[EMAIL PROTECTED]> wrote: > > An example: > I have a join across 10 tables + 2 subselects across 4 tables > on the machine I use for testing: > planner: 12 seconds > executor: 1 second > > The application will stay the same forever. > I could be 10 times faster if there was a way to load the execution plan > into the backend.
One option you have is to explicitly give the join order. You can look at explain to see what order the joins are done in and then rewrite the sql to force them to be done in that order. This should keep things simple for the planner. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
