On Mon, Mar 24, 2008 at 11:02:18AM +0200, Henry wrote:
> Hello all,
> 
> During an initial replication from a master to many slaves, why does slony
> perform an ANALYZE after the COPY?  For paltry tables this is OK, but for

For the same reason you need to ANALYSE after a restore from backup.

> massive (multiple GB) tables, this is something which takes frigging
> *days* per table.

?!  If so, you have something wrong.  ANALYSE shouldn't take that long.  It
samples the table.

> Even if there is a valid reason to analyze after a copy, is there a way to
> disable this behavior (short of hacking the src)?  The docs don't tell me
> much.

Nope.  Your performance on replication will be totally miserable without it. 
You MUST do it.

A