Re: [GENERAL] Speed of lo_unlink vs. DELETE on BYTEA

[Reuven M. Lerner]

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