[postgis-devel] Vegetable Gardening

Paragon Corporation lr at pcorp.us
Wed Nov 24 20:03:53 PST 2010


Which vegetable do you want?  You don't want any mutant vegetables?   Well I
do have the subset test, but I haven't updated that in a while -- I still
need to clean that up and put in logging logic.
That reduces the number of tests to whatever functions you filter by, but it
currently doesn't do any logging.
http://trac.osgeo.org/postgis/wiki/DevWikiGardenTest (the testing subset of
functions)

Have you looked at the log tables generated in the database?

Right now I'm just using that for logging completion or failure and also
timing.  I also use that as a quick scan to see things that are failing that
shouldn't be and then find the log label line of that section in the log
that looks suspicious.

Which I'm using to do some stats in R.  Like these raster profile snippets:
64BF looks a bit worse than everything else in general timing for example

-- across is time and down are pixel types (numbers are the counts of tests
for that pixel type that take that x amount of seconds)

       0 0.01 0.02 0.03 0.04 0.05 0.06 0.07 0.08 0.09 0.1 0.11
16BSI 78    9   17    3    3    4    0    2    2    0   0    0
16BUI 77   10   17    2    3    4    0    3    0    0   0    2
1BB   81   15   12    4    4    0    0    1    0    1   0    0
2BUI  82   15    9    5    4    0    0    0    2    0   1    0
32BF  78    9    6    2   14    2    0    5    0    0   1    1
32BSI 80    6    5    1   13    3    3    7    0    0   0    0
32BUI 80    7    6    0   12    4    3    6    0    0   0    0
4BUI  82   16    9    3    5    1    0    0    2    0   0    0
64BF  80    8    5    0    0    0    2    2   14    2   0    5
8BSI  82   16   11    2    4    1    0    1    1    0   0    0
8BUI  83   15   10    3    4    0    0    1    2    0   0    0

-- this one just tallies which functions take more than 0.06 secs to
complete. (something seems funky with that ST_BandMetaData for example)
                              FALSE TRUE
&&                              121    0
&<                              121    0
&>                              121    0
AddRasterColumn                  11    0
DropRasterTable                  11    0
insert data                      11    0
PostGIS_Raster_Lib_Build_Date     1    0
PostGIS_Raster_Lib_Version        1    0
ST_AddBand                       47   19
ST_AsBinary                      10    1
ST_BandHasNoDataValue            22    0
ST_BandMetaData                   0   22
ST_BandNoDataValue               22    0
ST_BandPath                      22    0
ST_BandPixelType                 22    0
ST_Box2D                         11    0
ST_ConvexHull                    11    0
ST_DumpAsPolygons                22    0
ST_Envelope                      11    0
ST_GeoReference                  22    0
ST_Height                        11    0
ST_Intersection                  44    0


Thanks,
Regina
 

-----Original Message-----
From: postgis-devel-bounces at postgis.refractions.net
[mailto:postgis-devel-bounces at postgis.refractions.net] On Behalf Of Paul
Ramsey
Sent: Wednesday, November 24, 2010 8:08 PM
To: PostGIS Development Discussion
Subject: [postgis-devel] Vegetable Gardening

While I love that the garden tests find things that otherwise would be
unfindable, I find dealing with the error reports a little hard.
"Here's a piece of SQL that generates 48 different function call
combinations, one of them fails." Is there any easier way to get the one
vegetable I want out of the garden?

P.
_______________________________________________
postgis-devel mailing list
postgis-devel at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-devel





More information about the postgis-devel mailing list