RE: cannot get CREATE TABLE AS to work

On Fri, 9 Mar 2001, Creager, Robert S wrote:

> 
> Well, that explains why I wasn't seeing any appreciable speed increase with
> the INITIALLY DEFERRED.  I tried mucking in pg_class, and saw a 3 fold
> increase in insert speed on inserts into my table with 2 relational
> triggers.  SET CONSTRAINTS ALL DEFERRED does nothing to very little to
> increase the insertion speed.  15min 'INITIALLY DEFERRED' vs 13min 'ALL
> DEFERRED' vs 5min 'pg_class update'.  And that 15 vs 13 could be machine
> activity.

Yeah, theoretically if we could do something where it knew that there were
alot of them and tried to fall back to doing a single big check rather
than lots of little ones we'd get a performance increase, but I can't
really think of a good way to do that with what we have right now...