On Wed, Apr 16, 2008 at 09:01:10AM -0400, Merlin Moncure wrote:
> On Wed, Apr 16, 2008 at 8:37 AM, Volkan YAZICI <[EMAIL PROTECTED]> wrote:
> > hubert depesz lubaczewski <[EMAIL PROTECTED]> writes:
> > > select i from generate_series(1,10) {hint:10} as i;
> > >
> > > i'm not proposiung syntax. i'm
On Wed, Apr 16, 2008 at 8:37 AM, Volkan YAZICI <[EMAIL PROTECTED]> wrote:
> hubert depesz lubaczewski <[EMAIL PROTECTED]> writes:
> > i think it would be better off not to limit some functionality for
> > builtin functions. it would be much nicer to have the ability to hint
> > planer about rowc
On Wed, Apr 16, 2008 at 03:37:22PM +0300, Volkan YAZICI wrote:
> I'm strongly declined for such non-SQL compliant solutions. I'd be
> appreciated if hackers can solve the problem internally, without bugging
> SQL syntax.
for generate_series - sure. but i have functions which change (in a
known way
hubert depesz lubaczewski <[EMAIL PROTECTED]> writes:
> i think it would be better off not to limit some functionality for
> builtin functions. it would be much nicer to have the ability to hint
> planer about rowcount from function *in* the sql.
>
> something like:
>
> select i from generate_serie
On Mon, Apr 14, 2008 at 11:21:58AM +0200, Harald Fuchs wrote:
> I think there's something sub-optimal with generate_series.
> In the following, "documents" is a table with more than 12 rows,
> vacuumed and analyzed before the queries.
> Since generate_series is a builtin function, can't it tell
In article <[EMAIL PROTECTED]>,
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> On Mon, Apr 14, 2008 at 5:21 AM, Harald Fuchs <[EMAIL PROTECTED]> wrote:
>> I think there's something sub-optimal with generate_series.
>> In the following, "documents" is a table with more than 12 rows,
>> vacuumed
On Mon, Apr 14, 2008 at 5:21 AM, Harald Fuchs <[EMAIL PROTECTED]> wrote:
> I think there's something sub-optimal with generate_series.
> In the following, "documents" is a table with more than 12 rows,
> vacuumed and analyzed before the queries.
everything is working exactly as intended. wh