Hi, everyone. Albe wrote:
Could you try with a trigger instead of a rule and see if the
performance is better? Yours,
Laurenz Albe
Great idea. I did that, and here are the results for 10,000
records:
| | Delete | Dump |
|---------------------------+-----------+-----------|
| Empty content | 8.162s | 0.064s |
| bytea | 1m0.417s | 0.157s |
| large object with rule | 4m44.501s | 1m38.454s |
| large object with trigger | 7m42.208s | 1m48.369s |
Ideas, anyone?
Reuven
--
Reuven M. Lerner -- Web development, consulting, and training
Mobile: +972-54-496-8405 * US phone: 847-230-9795
Skype/AIM: reuvenlerner