| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | "Creager, Robert S" <CreagRS(at)LOUISVILLE(dot)STORTEK(dot)COM> |
| Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, sqllist <pgsql-sql(at)postgresql(dot)org> |
| Subject: | RE: cannot get CREATE TABLE AS to work |
| Date: | 2001-03-09 21:26:26 |
| Message-ID: | Pine.BSF.4.21.0103091323390.81880-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brent R. Matzelle | 2001-03-09 21:54:38 | Re: (blowfish in Postgres) Undefined symbol -- YAY! |
| Previous Message | Creager, Robert S | 2001-03-09 20:59:22 | RE: cannot get CREATE TABLE AS to work |