Re: PostgreSQL - 'SKYLINE OF' clause added!

Yep - we're paying attention Josh!

I like the category being explored with skyline, I'm not sure yet how it fits with existing 'soft data' models and applications that use them.

If SKYLINE is interesting to app developers, maybe we should consider it for Bizgres?

- Luke

Msg is shrt cuz m on ma treo

-----Original Message-----
From: Gavin Sherry [mailto:swm(at)alcove(dot)com(dot)au]
Sent: Wednesday, March 07, 2007 05:44 PM Eastern Standard Time
To: Josh Berkus
Cc: Tom Lane; pgsql-hackers(at)postgresql(dot)org; Alvaro Herrera; Chris Browne
Subject: Re: [HACKERS] PostgreSQL - 'SKYLINE OF' clause added!

On Wed, 7 Mar 2007, Josh Berkus wrote:

> "Approximate queries" is something with DSS users *want*. Jim Grey addressed
> this in his ACM editiorial on the databases of the future. It's something
> that *I* want, and if the Greenplum people aren't speaking up here, it's
> because they're not paying atttention.
>
> Now, I don't know if this Skyline patch is our answer for approximate queries.
> Maybe I should pester Meredith about getting QBE free of its IP issues; it
> certainly looked more flexible than Skyline. In either case, the code
> probably needs a complete refactor.

What people want from "approximate queries" is different to this: the
desire is usually to balance run time with level of accuracy/quality (some
times the desire is to have accurate results as well as similar results).
Neither skyline or QBE are about this. The only thing in the spec which
addresses this is 'tablesample'.

Thanks,

Gavin

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match