From: Yeb Havinga <yebhavinga@gmail.com>
To: Craig Ringer <craig@postnewspapers.com.au>
Cc: LaboRecherche <nomail@altranx.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Using SKYLINE command on PostgreSQL
Date: Sun, 8 Aug 2010 15:40:07 +0200
Message-ID: <AANLkTinnVM-gqAXzV4jgr6F+CVH3wUa9R7inXmWHpDeP@mail.gmail.com> (raw)
In-Reply-To: <4C5E25FC.9080303@postnewspapers.com.au>
References: <i3c4a7$j6r$1@speranza.aioe.org>
<4C5E25FC.9080303@postnewspapers.com.au>
On Sun, Aug 8, 2010 at 5:35 AM, Craig Ringer <craig@postnewspapers.com.au>wrote:
>
> The masters thesis page does contain a patch against PostgreSQL 8.3:
> http://skyline.dbai.tuwien.ac.at/
>
That page has a nice web page and examples where queries can be run. 'The
skyline operator' is described in
http://www.dbis.ethz.ch/research/publications/38.pdf. It reminds me a bit of
the staircase join operator, something on my personal wish list for postgres
as well (latest patch seems to have got lost on the internet).
>
> They say they're porting the patch to 8.4devel, but I suspect that since
> 8.4 has been out for ages and 9.0 is almost released, they've probably
> lost interest and dropped the work.
>
I looked a bit in the latest patch. There's a lot of FIXME's and TODO's in
it. It adds at least one plan node, so it's probably hard to rewrite into
contrib form. That'll probably make it harder to get accepted for mainline
postgres, also because the skyline queries can be translated into 'normal'
sql (referenced pdf, section 3.1), though the authors claim the performance
using skyline is better. Since 8.3 CTE's have been introduced and maybe that
makes writing these kinds of queries easier. Also the knngist ordering of
'interesting points' might be a solution for problems in the same ballpark.
regards,
Yeb Havinga
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: yebhavinga@gmail.com, craig@postnewspapers.com.au, nomail@altranx.com
Subject: Re: Using SKYLINE command on PostgreSQL
In-Reply-To: <AANLkTinnVM-gqAXzV4jgr6F+CVH3wUa9R7inXmWHpDeP@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox