Postgres Pro
Downloads
Home   >   mailing lists

Re: Speed of lo_unlink vs. DELETE on BYTEA - Mailing list pgsql-general

From Reuven M. Lerner
Subject Re: Speed of lo_unlink vs. DELETE on BYTEA
Date
Msg-id 4E7C8A4B.9070609@lerner.co.il
Whole thread Raw
In response to Re: Speed of lo_unlink vs. DELETE on BYTEA  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general
Tree view 
body p { margin-bottom: 10pt; margin-top: 0pt; }

  <body style="direction: ltr;"
    bidimailui-detected-decoding-type="UTF-8" bgcolor="#FFFFFF"
    text="#000000">
    Hi, everyone. Albe wrote:
    <blockquote
cite="mid:D960CB61B694CF459DCFB4B0128514C2049FCE78@exadv11.host.magwien.gv.at"
      type="cite">
      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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: : Checksum ERROR when restoring Online Backup
Next
From: Roger Niederland
Date:
Subject: pg_dump compress