Guillaume, * Guillaume Smet ([EMAIL PROTECTED]) wrote: > These servers are available 24/7 to PostgreSQL QA and won't be used > for other purposes.
Awesome. > Concerning the second point, I wonder if it's not worth it to have a > very simple thing already reporting results as the development cycle > for 8.4 has already started (perhaps several pgbench unit tests > testing various type of queries with a daily tree). Thoughts? It didn't occur to me before, but, if you've got a decent amount of disk space and server time.. I'm almost done scripting up everything to load the TIGER/Line Shapefiles from the US Census into PostgreSQL/PostGIS. Once it's done and working I would be happy to provide it to whomever asks, and it might be an interesting data set to load/query and look at benchmarks with. There's alot of GIST index creation, as well as other indexes like soundex(), and I'm planning to use partitioning of some sort for the geocoder. We could, for example, come up with some set of arbitrary addresses to geocode and see what the performance of that is. It's just a thought, and it's a large/"real" data set to play with. The data set is 22G compressed shapefiles/dbf files. Based on my initial numers I think it'll grow to around 50G loaded into PostgreSQL (I'll have better numbers later today). You can get the files from here: http://ftp2.census.gov/geo/tiger/TIGER2007FE/ Or, if you run into a problem with that, I can provide a pretty fast site to pull them from as well (15Mb/s). Thanks, Stephen
signature.asc
Description: Digital signature