[Pdns-users] PowerDNS needs your thoughts on two important DNSSEC matters

Peter van Dijk peter.van.dijk at netherlabs.nl
Mon Sep 3 19:23:34 UTC 2012


On Sep 3, 2012, at 21:15 , Peter van Dijk wrote:

> Great tips from #postgresql:
> 1.  ORDER BY col USING ~<~  - apparently undocumented, but it sorts the right way.
> 1) can use indexes that use the text_pattern_ops opclass

Comparisons like < and > would then be replaced by ~<~ and ~>~ etcetera.

"the obvious choice of index would be  records (domain_id, ordername text_pattern_ops)"

(thanks to Andrew 'RhodiumToad' Gierth of #postgresql)

Kind regards,
Peter van Dijk
Netherlabs Computer Consulting BV - http://www.netherlabs.nl/

More information about the Pdns-users mailing list