Re: Speed of lo_unlink vs. DELETE on BYTEA

Поиск
Список
Период
Сортировка
От Reuven M. Lerner
Тема Re: Speed of lo_unlink vs. DELETE on BYTEA
Дата
Msg-id 4E7C8A4B.9070609@lerner.co.il
обсуждение исходный текст
Ответ на Re: Speed of lo_unlink vs. DELETE on BYTEA  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Список pgsql-general
Дерево обсуждения 
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 по дате отправления: