Simon Riggs simon at 2ndquadrant.com
Fri Dec 14 02:03:53 PST 2007
in copy_set() line 3073 of /src/slon/remote_worker.c

uses DELETE rather than TRUNCATE prior to COPY


So some optimizations here could be
- use TRUNCATE to speed up refreshing a copy operation
- this will then allow (from 8.3 onwards) fast COPY mode

It's possible you've decided we don't need that part to be optimized,
which is OK, I'm just pointing out what's possible.

-- 
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com



More information about the Slony1-general mailing list