| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Matthew <matt(at)ctlno(dot)com>, Bill Huff <bhuff(at)colltech(dot)com> |
| Cc: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Poor Delete performance |
| Date: | 2001-03-12 23:10:08 |
| Message-ID: | 7477.984438608@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I've applied a patch for this problem to current sources. The
improvement was more than I expected --- a test case involving
deleting 80000 tuples from a foreign-key-referencing table dropped
from ~15min to ~8sec. Insertion of a large number of tuples in one
transaction sped up quite a bit too.
If you are in a hurry for a fix, you could probably adapt the diff
to 7.0.3 sources:
http://www.postgresql.org/cgi/cvsweb.cgi/pgsql/src/backend/commands/trigger.c.diff?r1=1.86&r2=1.87&f=c
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-03-12 23:22:35 | Re: Postgresql 7.1 Beta 5, Postmaster dead |
| Previous Message | Feite Brekeveld | 2001-03-12 22:45:13 | please some help on trigger creation |