Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 7 Jul 2014 05:27:17 +0000 (UTC)
From:      Kurt Jaeger <pi@FreeBSD.org>
To:        ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org
Subject:   svn commit: r361022 - head/databases/ip4r
Message-ID:  <201407070527.s675RHZq053466@svn.freebsd.org>

next in thread | raw e-mail | index | archive | help
Author: pi
Date: Mon Jul  7 05:27:17 2014
New Revision: 361022
URL: http://svnweb.freebsd.org/changeset/ports/361022
QAT: https://qat.redports.org/buildarchive/r361022/

Log:
  databases/ip4r: patch to prefer ip4r indexes over seq_scan on large datasets
  
  - add option to prefer ip4r indexes over seq_scan on large datasets
  
  PR:		190104
  Submitted by:	michelle@sorbs.net
  Approved by:	maintainer (timeout)

Modified:
  head/databases/ip4r/Makefile
  head/databases/ip4r/distinfo

Modified: head/databases/ip4r/Makefile
==============================================================================
--- head/databases/ip4r/Makefile	Mon Jul  7 04:44:07 2014	(r361021)
+++ head/databases/ip4r/Makefile	Mon Jul  7 05:27:17 2014	(r361022)
@@ -9,10 +9,22 @@ MASTER_SITES=	http://pgfoundry.org/frs/d
 MAINTAINER=	tobez@FreeBSD.org
 COMMENT=	IP address and IP range index types for PostgreSQL
 
+OPTIONS_DEFINE=	IDXPATCH
+
+IDXPATCH_DESC=	Prefer ip4r indexes over seq_scan on large datasets
+
 USES=		gmake pgsql
 
 MAKE_ARGS=	USE_PGXS=1
 
+.include <bsd.port.options.mk>
+
+.if ${PORT_OPTIONS:MIDXPATCH}
+# Patch if the option is supplied, however we need to unpatch if the option is de-selected after previously selecting (TODO)
+PATCH_SITES=	http://www.sorbs.net/home/:SORBS
+PATCHFILES=	ip4r-2.x-SORBS-prefer-index.patch:-p1:SORBS
+.endif
+
 # In order to make this port PREFIX-safe, we override the install target
 # and install the three files manually
 do-install:

Modified: head/databases/ip4r/distinfo
==============================================================================
--- head/databases/ip4r/distinfo	Mon Jul  7 04:44:07 2014	(r361021)
+++ head/databases/ip4r/distinfo	Mon Jul  7 05:27:17 2014	(r361022)
@@ -1,2 +1,4 @@
 SHA256 (ip4r-2.0.tar.gz) = 251e70d12fc1244aab1707d3db0fe9f821ab224765e34cd8f2fb66ee3468a957
 SIZE (ip4r-2.0.tar.gz) = 93007
+SHA256 (ip4r-2.x-SORBS-prefer-index.patch) = 4c10dcb0c31b6abe012597fc7826ccff2611c8ef256bbc5d448633cfb3b60427
+SIZE (ip4r-2.x-SORBS-prefer-index.patch) = 9221



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201407070527.s675RHZq053466>