[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