[postgis-tickets] r15127 - Amend garden tests to test BRIN indexes for geometry and geography

[Regina Obe]

Author: robe
Date: 2016-09-21 13:11:50 -0700 (Wed, 21 Sep 2016)
New Revision: 15127

Modified:
   trunk/doc/xsl/postgis_gardentest.sql.xsl
Log:
Amend garden tests to test BRIN indexes for geometry and geography
closes #3619

Modified: trunk/doc/xsl/postgis_gardentest.sql.xsl
===================================================================
--- trunk/doc/xsl/postgis_gardentest.sql.xsl	2016-09-21 19:44:46 UTC (rev 15126)
+++ trunk/doc/xsl/postgis_gardentest.sql.xsl	2016-09-21 20:11:50 UTC (rev 15127)
@@ -11,7 +11,7 @@
 	<xsl:variable name='testversion'>2.3.0</xsl:variable>
 	<xsl:variable name='fnexclude14'>AddGeometryColumn DropGeometryColumn DropGeometryTable</xsl:variable>
 	<xsl:variable name='fnexclude'>AddGeometryColumn DropGeometryColumn DropGeometryTable</xsl:variable>
-	<!--This is just a place holder to state functions not supported in 1.3 or tested separately -->
+	<!--This is just a place holder to state functions not supported or tested separately -->
 
 	<xsl:variable name='var_srid'>3395</xsl:variable>
 	<xsl:variable name='var_position'>1</xsl:variable>
@@ -314,7 +314,15 @@
 COMMIT;
 SELECT '<xsl:value-of select="$log_label" /> geometry index: End Testing <xsl:value-of select="@ID" />';
 
+SELECT '<xsl:value-of select="$log_label" /> Geometry brin index: Start Testing <xsl:value-of select="@ID" />';
+INSERT INTO <xsl:value-of select="$var_logtable" />(log_label, func, g1, log_start) VALUES('<xsl:value-of select="$log_label" /> brin index Geometry','CREATE brin index geometry', '<xsl:value-of select="@ID" />', clock_timestamp());
+BEGIN;
+	CREATE INDEX idx_pgis_geom_brin ON pgis_garden USING brin(the_geom);
+	<xsl:value-of select="$var_logupdatesql" />
+COMMIT;
+SELECT '<xsl:value-of select="$log_label" /> geometry brin index: End Testing <xsl:value-of select="@ID" />';
 
+
 INSERT INTO <xsl:value-of select="$var_logtable" />(log_label, func, g1, log_start, log_sql) 
 VALUES('<xsl:value-of select="$log_label" /> insert data Geometry','insert data', '<xsl:value-of select="@ID" />', clock_timestamp(), '<xsl:call-template name="escapesinglequotes">
  <xsl:with-param name="arg1">INSERT INTO pgis_garden(the_geom, the_geom_multi)
@@ -388,7 +396,15 @@
 COMMIT;
 SELECT '<xsl:value-of select="$log_label" /> Geography index: End Testing <xsl:value-of select="@ID" />';
 
+SELECT '<xsl:value-of select="$log_label" /> Geography brin index: Start Testing <xsl:value-of select="@ID" />';
+INSERT INTO <xsl:value-of select="$var_logtable" />(log_label, func, g1, log_start) VALUES('<xsl:value-of select="$log_label" /> brin index Geography','CREATE brin index geography', '<xsl:value-of select="@ID" />', clock_timestamp());
+BEGIN;
+	CREATE INDEX idx_pgis_geoggarden_geog_brin ON pgis_geoggarden USING brin(the_geog);
+	<xsl:value-of select="$var_logupdatesql" />
+COMMIT;
+SELECT '<xsl:value-of select="$log_label" /> Geography brin index: End Testing <xsl:value-of select="@ID" />';
 
+
 <!-- vacuum analyze can't be put in a commit so we can't completely tell if it completes if it doesn't crash -->
 INSERT INTO <xsl:value-of select="$var_logtable" />(log_label, func, g1, log_start, log_sql) VALUES('<xsl:value-of select="$log_label" /> vacuum analyze Geography','analyze geography table', '<xsl:value-of select="@ID" />', clock_timestamp(),
     'VACUUM ANALYZE pgis_geoggarden;');