Planner features, discussion

From: pasman pasmański <pasman(dot)p(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Planner features, discussion
Date: 2010-07-13 11:49:23
Message-ID: AANLkTin8UQQb-zjUPvU8RE2ofu6TIFjr6IqVzcGIOQxP@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello.

I propose 2 features for planner:

1. Planner will estimate 2 x statistics: time of query with cache empty
and with cache filled.

2. Two levels of plannig: standard and long.
Long planning may be used when standard optimization
generate slow plan, and may use advanced algebraic transformations:

F( F(a,1), 2) = F(a, F(1,2) ) - for algebraic groups for example etc.

------------
pasman

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andras Fabian 2010-07-13 12:07:21 Re: PG_DUMP very slow because of STDOUT ??
Previous Message Steve Clark 2010-07-13 11:36:36 Re: PG_DUMP very slow because of STDOUT ??