Re: Speed of lo_unlink vs. DELETE on BYTEA

"Reuven M. Lerner" <reuven@xxxxxxxxxxxx> · Fri, 23 Sep 2011 16:31:55 +0300



    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