Re: sql row constructor...works! - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: sql row constructor...works!
Date
Msg-id 43E8DA05.3000104@agliodbs.com
Whole thread Raw
In response to sql row constructor...works!  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: sql row constructor...works!
List 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


pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: sql row constructor...works!
Next
From: Tom Lane
Date:
Subject: Re: [PORTS] Failed install - libgen.so doesn't exist