On Thu, Dec 9, 2010 at 11:56 AM, Dimitri Fontaine <[email protected]> wrote: > Merlin Moncure <[email protected]> writes: >> On Wed, Dec 8, 2010 at 8:57 AM, Tatsuo Ishii <[email protected]> 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/[email protected]
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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
