+1 here. I think we sorted out most of the issues involved with protocol
changes between postgresql 8 and postgresql 9 a while back. It might be a
good idea to at least manually verify (with the unit tests) a few older
database versions work with the new driver before making it the default.
Oh and it looks they changed the maven groupId for more recent versions of
the driver, from "postgresql" to "org.postgresql".
On my dev machine i am running postgresql 9.3.1 and just tried with the
driver version you specified and got a few failures, but not sure if they
are related to server/driver version combo or not.
PostGISFunctionTest>OnlineTestCase.run:123->JDBCFunctionTest.testStrEndsWithOtherProperty:101->JDBCFunctionTest.assertFeatures:319
Expected to find 3 features, but was 1
PostgisDateTest>OnlineTestCase.run:123->JDBCDateTest.testFiltersByDate:45
expected:<2> but was:<1>
PostgisDateTest>OnlineTestCase.run:123->JDBCDateTest.testFiltersByDate:45
expected:<2> but was:<1>
On Sat, Jan 4, 2014 at 2:27 PM, Andrea Aime <[email protected]>wrote:
> Hi,
> during the current work break I've run a fair number of benchmarks
> (detailed
> on the GeoServer lists, see these threads:
>
> http://osgeo-org.1560.x6.nabble.com/Some-interesting-optmizations-from-Jonathan-s-load-test-td5095839.html
>
> http://osgeo-org.1560.x6.nabble.com/PostGIS-ST-Simplify-over-the-FOSS4G-2010-benchmark-shall-we-enable-it-by-default-td5096367.html
>
> (and btw, notice that I'm proposing to enable the usage of ST_Simplify any
> time the Hints.GEOMETRY_DISTANCE
> hint is provided in the Query)
>
>
> While I was at it, and since there has been requests to upgrade our aging
> postgresql driver,
> I've run the postgis related benchmarks against the old and new driver,
> using two benchmarks:
> * the FOSS4G 2010 one, that has "light" maps (not very much drawn in each
> request)
> * Warwishire sample benchmark, opposite end of the spectrum, rather busy
> maps instead
>
> The numbers in both cases are pretty much the same, with deviations that
> globally are within 5% above
> or below, and in average, pretty close to 1% deviation.
>
> So, I'd be in favor of upgrading the driver to the newest version,
> 9.3-1100-jdbc41, on the master
> series (which is going to be released as beta in two weeks)
>
> Opinions?
>
> Cheers
> Andrea
>
> --
> *== GeoSolutions will be closed for seasonal holidays from 23/12/2013 to
> 06/01/2014 ==*
>
> Ing. Andrea Aime
> @geowolf
> Technical Lead
>
> GeoSolutions S.A.S.
> Via Poggio alle Viti 1187
> 55054 Massarosa (LU)
> Italy
> phone: +39 0584 962313
> fax: +39 0584 1660272
> mob: +39 339 8844549
>
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
>
> -------------------------------------------------------
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
> _______________________________________________
> GeoTools-Devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geotools-devel
>
>
--
*Justin Deoliveira*
Vice President, Engineering | Boundless
[email protected]
@j_deolive <https://twitter.com/j_deolive>
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
GeoTools-Devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
