| 00:18:59 | jxhnson: | Hello all. I have a question about the svn version of PostGIS - I have 1.3.3 installed at the moment, but I'm looking to use the new st_asgeojson function, which as far as I can tell is only in the svn version. |
| 00:19:31 | jxhnson: | But it seems that the svn copy doesn't have the lwpostgis_upgrade.sql script - so is a hard upgrade my only option? |
| 00:26:19 | jxhnson: | nevermind...just found postgis_proc_upgrade.pl |
| 03:42:00 | CIA-6: | robe * r2895 /trunk/lwgeom/ ( lwpostgis.sql.in.c sqlmm.sql.in ): |
| 03:42:00 | CIA-6: | Got rid pf superfluous redirection to deprecated functions of ST_GeomFromWkb and |
| 03:42:01 | CIA-6: | ST_GeomFromText - now they just point directly to the c functions. Changed all |
| 03:42:01 | CIA-6: | FromWKB, FromText variants to point to the non-deprecated ST_GeomFrom, |
| 03:42:01 | CIA-6: | ST_BuildArea etc. ( before they were pointing at deprecated functions ) |
| 06:05:28 | CIA-6: | robe * r2896 /trunk/doc/ ( reference.xml reference_new.xml ): Move over ST_WKTToSQL and also defined ST_GeometryFromText ( didn't see it in the old docs, but its not deprecated and is a popular variant ) |
| 11:53:30 | hobu: | pramsey: my osx box crashed before vacuum full finished |
| 11:53:47 | pramsey: | blummer |
| 11:54:00 | hobu: | I did some dtrace on the postgres process and it looks like it was spending craploads of time reinserting stuff in the index |
| 11:54:29 | hobu: | it ran for ~16 hours before blowing up ( totally freezing my box ) |
| 11:55:14 | hobu: | plan C is to pg_dump the db and recreate it |
| 11:55:16 | pramsey: | drop index, vacuum, try again? |
| 11:55:30 | hobu: | tried that |
| 11:55:40 | hobu: | vacuum full is the only thing that will recover disk space |
| 11:55:59 | pramsey: | create table newtable as select * from oldtable; drop oldtable; |
| 11:56:08 | hobu: | I did at least 8 updates to this giant table |
| 11:56:11 | pramsey: | rename oldtable newtable; |
| 11:56:28 | pramsey: | er, vice verse |
| 11:57:50 | hobu: | can't do that. Don't have enough disk space on the drive with the $DATA directory to copy the table |
| 12:01:48 | pramsey: | well you aren't makingt his easy : ) |
| 12:02:16 | pramsey: | if you dump'n'restore remember to set fsync off during the load |
| 12:02:20 | pramsey: | save a lot of load time |
| 12:02:27 | : | * hobu nods |
| 18:32:35 | sigq: | geosfeed: Ticket #194 ( defect updated ): Unbuffered geometries using negative distances <http://trac.osgeo.org/geos/ticket/194#comment:1> |
| 20:58:07 | CIA-6: | kneufeld * r2897 /trunk/doc/ ( 3 files in 3 dirs ): replaced the mathematical gif expression in ST_Crosses with simple html markup |
| 22:30:20 | CIA-6: | kneufeld * r2898 /trunk/doc/ ( reference.xml reference_new.xml ): Moved over ST_Touches to new PostGIS reference. Examples forthcoming. |
| 22:33:35 | CIA-6: | kneufeld * r2899 /trunk/doc/reference_new.xml: fixed small typo in ST_Touches mathematical expression |
| 22:35:37 | CIA-6: | robe * r2900 /branches/1.3/doc/postgis.xml: Put in Availability 1.3.4 for ST_AsGeoJSON |
| 22:36:18 | CIA-6: | robe * r2901 /trunk/doc/reference.xml: Put in Availability 1.3.4 for ST_AsGeoJSON |