Re: sql row constructor...works!

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: sql row constructor...works!
Date: 2006-02-07 17:33:57
Message-ID: 43E8DA05.3000104@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Merlin,

> Thanks for bringing the SQL 92 row constructor into spec for
> operations involving > and <. This is just fantastic. I just
> benchmarked ISAM style access to tables on multi-part keys and the
> speedup is tremendous vs. the non row-constructor approach to the
> problem which is tedius to write and only selective to the first part
> of the key. We are talking speedups proportional to the inselectivity
> of the ordering key. While this feature is relatively esoteric, it is
> powerful and belongs in every dba's bag of tricks.

It's esoteric enough that I don't know what you're talking about. Can
you give us an example?

--Josh

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-02-07 17:34:27 Re: [PORTS] Failed install - libgen.so doesn't exist
Previous Message Merlin Moncure 2006-02-07 17:31:05 sql row constructor...works!