Re: md5 of table

Поиск
Список
Период
Сортировка
От Sim Zacks
Тема Re: md5 of table
Дата
Msg-id 4E5F762E.7030103@compulab.co.il
обсуждение исходный текст
Ответ на Re: md5 of table  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Список pgsql-general
Дерево обсуждения 
<meta content=3D"text/html; charset=3DUTF-8" http-equiv=3D"Content-Type=
">
    body p { margin-bottom: 0cm; margin-top: 0pt; }

  <body style=3D"direction: ltr;"
    bidimailui-detected-decoding-type=3D"UTF-8" bgcolor=3D"#ffffff"
    text=3D"#000000">
    On 09/01/2011 01:35 PM, Grzegorz Ja=C5=9Bkiewicz wrote:
    <blockquote
cite=3D"mid:CAJY59_h6TqWfh3NKxfDCq1Pb9hBcYGBqxb5h+czWcgLj4ETeGQ@mail.gmail.=
com"
      type=3D"cite">
      On Thu, Sep 1, 2011 at 11:14 AM, Sim Zacks <a class=3D=
"moz-txt-link-rfc2396E" href=3D"mailto:sim@compulab.co.il"><sim@compulab=
.co.il> wrote:


        On 09/01/2011 12:26 PM, Pavel Stehule wrote:



Hello

postgres=3D# create table tt(a int, b varchar);
CREATE TABLE
postgres=3D# insert into tt values(10,'hello');
INSERT 0 1

postgres=3D# select md5(array_to_string(array_agg(md5(tt::text)),'')) from



      I do that as well, but it might have questionable perf=
ormance when
your table has 16M rows, and is 50GB +


    I don't need performance. This is for regression testing for a
      new database version. I want to run my functions in the old db and
      the new db and when it modifies a table, I want to be able to
      check that the tables are the same.
    Sim

В списке pgsql-general по дате отправления: