On Thu, Dec 9, 2010 at 11:56 AM, Dimitri Fontaine <dimi...@2ndquadrant.fr> wrote: > Merlin Moncure <mmonc...@gmail.com> writes: >> On Wed, Dec 8, 2010 at 8:57 AM, Tatsuo Ishii <is...@postgresql.org> wrote: >>> >>> Then execute the huge SELECT: >>> http://codezine.jp/static/images/article/1629/html/sql.html >> >> benchmark what you've got against this (ported to postgres by marcin mank): >> http://www.pastie.org/684163 > > It that this one ? > > http://archives.postgresql.org/message-id/e08cc0400911042333o5361b21cu2c9438f82b1e5...@mail.gmail.com
sure is -- I missed the formatted version. The original query also an Oracle original. If you remove the 'where ind = 0', you can watch the database solve the puzzle, which is pretty neat. merlin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
