From: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
---|---|
To: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
Cc: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Peter Childs <Blue(dot)Dragon(at)blueyonder(dot)co(dot)uk>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [GENERAL] 7.4Beta |
Date: | 2003-08-15 09:17:26 |
Message-ID: | 3F3CA526.1020404@pse-consulting.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Stephan Szabo wrote:
>On Fri, 15 Aug 2003, Christopher Kings-Lynne wrote:
>
>
>
>>>>I throw last nights backup at it. Data went in in about 1/2 an hour then
>>>>
>>>>
>>the
>>
>>
>>>>constraints went in and they took at age. about 2 hours.....
>>>>Is there anyway to speed up the database constraint code? Because quite
>>>>frankly at the current speed your probably better off without the
>>>>constraints.... (Same problem with 7.3 come to think about it.)
>>>>
>>>>
>>I can also attest to the horrendously long time it takes to restore the ADD
>>FOREIGN KEY section...
>>
>>
>
>That really needs to be rewritten to do a single check over the table
>rather than running the constraint for every row. I keep meaning to get
>around to it and never actually do. :( I'm not sure that in practice
>you'll get a better plan at restore time depending on what the default
>statistics give you.
>
This is clearly a case for a statement level trigger, as soon as
affected rows can be identified.
One remark on that enable/disable triggers stuff: from a user's
perspective, I wouldn't consider a constraint trigger as a trigger, so
if I'd disable all triggers on a table, I still would expect all
constraints to be checked.
Regards,
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2003-08-15 09:41:21 | join of array |
Previous Message | Oleg Bartunov | 2003-08-15 08:27:15 | Re: tsearch2 in 7.4beta1 compile problem |
From | Date | Subject | |
---|---|---|---|
Next Message | Toni Schlichting | 2003-08-15 10:06:04 | Re: On Linux Filesystems |
Previous Message | Stephan Szabo | 2003-08-15 07:33:59 | Re: [GENERAL] 7.4Beta |