[rttopo-dev] reserving face identifiers for state flags

[Sandro Santilli]

On Wed, Sep 14, 2016 at 12:21:16PM -0400, Brian M Hamlin wrote:
> As far as I know, a DELETE should be cheap, since the ROW is just marked for deletion
> 
> UPDATE is very expensive, and for large tables and large sets, a complete rewrite (new table) is faster
> 
> VACUUM is slow and can occur anytime, especially after a DELETE
> I suspect you are seeing a VACUUM ?

I'm afraid I was seeing a lack of index on the
node.containing_face field, which is a foreign key to
face.face_id. See https://trac.osgeo.org/postgis/ticket/2861#comment:2

--strk;