Planner features, discussion - Mailing list pgsql-general

From pasman pasmański
Subject Planner features, discussion
Date
Msg-id AANLkTin8UQQb-zjUPvU8RE2ofu6TIFjr6IqVzcGIOQxP@mail.gmail.com
Whole thread Raw
Responses Re: Planner features, discussion  (Craig Ringer <craig@postnewspapers.com.au>)
Re: Planner features, discussion  (Greg Smith <greg@2ndquadrant.com>)
List 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

pgsql-general by date:

Previous
From: Andras Fabian
Date:
Subject: Re: PG_DUMP very slow because of STDOUT ??
Next
From: Steve Clark
Date:
Subject: Re: PG_DUMP very slow because of STDOUT ??