<html style="direction: ltr;">
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<style>body p { margin-bottom: 10pt; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="UTF-8" bgcolor="#FFFFFF"
text="#000000">
Hi, everyone. Albe wrote:
<blockquote
cite="mid:D960CB61B694CF459DCFB4B0128514C2049FCE78(at)exadv11(dot)host(dot)magwien(dot)gv(dot)at"
type="cite">
Could you try with a trigger instead of a rule and see if the
performance is better? Yours,
Laurenz Albe
</blockquote>
Great idea. I did that, and here are the results for 10,000
records:<br>
<br>
<tt>| | Delete | Dump |<br>
|---------------------------+-----------+-----------|<br>
| Empty content | 8.162s | 0.064s |<br>
| bytea | 1m0.417s | 0.157s |<br>
| large object with rule | 4m44.501s | 1m38.454s |<br>
| large object with trigger | 7m42.208s | 1m48.369s |</tt><br>
<br>
Ideas, anyone? <br>
<br>
Reuven<br>
<pre class="moz-signature" cols="72">--
Reuven M. Lerner -- Web development, consulting, and training
Mobile: +972-54-496-8405 * US phone: 847-230-9795
Skype/AIM: reuvenlerner
</pre>
</body>
</html>