| From: | Sim Zacks <sim(at)compulab(dot)co(dot)il> |
|---|---|
| To: | PostgreSQL general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: md5 of table |
| Date: | 2011-09-01 12:10:22 |
| Message-ID: | 4E5F762E.7030103@compulab.co.il |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html style="direction: ltr;">
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<style>body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="UTF-8" bgcolor="#ffffff"
text="#000000">
On 09/01/2011 01:35 PM, Grzegorz Jaśkiewicz wrote:
<blockquote
cite="mid:CAJY59_h6TqWfh3NKxfDCq1Pb9hBcYGBqxb5h+czWcgLj4ETeGQ(at)mail(dot)gmail(dot)com"
type="cite">
<pre wrap="">On Thu, Sep 1, 2011 at 11:14 AM, Sim Zacks <a class="moz-txt-link-rfc2396E" href="mailto:sim(at)compulab(dot)co(dot)il"><sim(at)compulab(dot)co(dot)il></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">On 09/01/2011 12:26 PM, Pavel Stehule wrote:
</pre>
<blockquote type="cite">
<pre wrap="">
Hello
postgres=# create table tt(a int, b varchar);
CREATE TABLE
postgres=# insert into tt values(10,'hello');
INSERT 0 1
postgres=# select md5(array_to_string(array_agg(md5(tt::text)),'')) from
</pre>
</blockquote>
</blockquote>
<pre wrap="">I do that as well, but it might have questionable performance when
your table has 16M rows, and is 50GB +
</pre>
</blockquote>
<p>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.</p>
<p>Sim<br>
</p>
</body>
</html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 1.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rik Bellens | 2011-09-01 12:16:30 | Re: strange table disk sizes |
| Previous Message | Bruce Momjian | 2011-09-01 11:53:39 | Re: [GENERAL] documentation suggestion |