Re: md5 of table - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: md5 of table
Date
Msg-id CAJY59_h6TqWfh3NKxfDCq1Pb9hBcYGBqxb5h+czWcgLj4ETeGQ@mail.gmail.com
Whole thread Raw
In response to Re: md5 of table  (Sim Zacks <sim@compulab.co.il>)
Responses Re: md5 of table
Re: md5 of table
List pgsql-general
On Thu, Sep 1, 2011 at 11:14 AM, Sim Zacks <sim@compulab.co.il> wrote:
> On 09/01/2011 12:26 PM, Pavel Stehule wrote:
>>
>> 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
I do that as well, but it might have questionable performance when
your table has 16M rows, and is 50GB +


--
GJ

pgsql-general by date:

Previous
From: Sim Zacks
Date:
Subject: Re: md5 of table
Next
From: Rik Bellens
Date:
Subject: strange table disk sizes