Re: md5 of table - Mailing list pgsql-general

From Sim Zacks
Subject Re: md5 of table
Date
Msg-id 4E5F762E.7030103@compulab.co.il
Whole thread Raw
In response to Re: md5 of table  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
List 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 by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: strange table disk sizes
Next
From: Rik Bellens
Date:
Subject: Re: strange table disk sizes