X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9EFCA53528 for ; Wed, 20 Apr 2005 17:42:33 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 37821-05 for ; Wed, 20 Apr 2005 20:42:29 +0000 (GMT) Received: from server07.icaen.uiowa.edu (server07.icaen.uiowa.edu [128.255.17.47]) by svr1.postgresql.org (Postfix) with ESMTP id 2E9C3537DC for ; Wed, 20 Apr 2005 17:42:27 -0300 (ADT) Received: from server11.icaen.uiowa.edu (server11.icaen.uiowa.edu [128.255.17.51]) by server07.icaen.uiowa.edu (8.13.3/8.12.9) with ESMTP id j3KKgPYu008389; (envelope-from ) Wed, 20 Apr 2005 15:42:25 -0500 (CDT) Received: from [192.168.1.11] (12-215-118-172.client.mchsi.com [12.215.118.172]) (authenticated user=jfmeinel) by server11.icaen.uiowa.edu (8.13.2/smtp-serv-1.7) with ESMTP id j3KKgNP5018863 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256); (envelope-from ) Wed, 20 Apr 2005 15:42:24 -0500 (CDT) Message-ID: <4266BEB0.3050008@arbash-meinel.com> Date: Wed, 20 Apr 2005 15:42:24 -0500 From: John A Meinel User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Joel Fradkin Cc: josh@agliodbs.com, pgsql-performance@postgresql.org Subject: Re: Joel's Performance Issues WAS : Opteron vs Xeon References: <000001c545e2$863d7ff0$797ba8c0@jfradkin> In-Reply-To: <000001c545e2$863d7ff0$797ba8c0@jfradkin> X-Enigmail-Version: 0.91.0.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigED29CEC84FC8E0FF9959219D" X-Virus-Scanned: ClamAV version 0.83, clamav-milter version 0.83 on clamav.icaen.uiowa.edu X-Virus-Scanned: ClamAV version 0.83, clamav-milter version 0.83 on clamav.icaen.uiowa.edu X-Virus-Status: Clean X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200504/533 X-Sequence-Number: 11930 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigED29CEC84FC8E0FF9959219D Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Joel Fradkin wrote: ... >I would of spent more $ with Command, but he does need my data base to help >me and I am not able to do that. > > ... What if someone were to write an anonymization script. Something that changes any of the "data" of the database, but leaves all of the relational information. It could turn all strings into some sort of hashed version, so you don't give out any identifiable information. It could even modify relational entries, as long as it updated both ends, and this didn't affect the actual performance at all. I don't think this would be very hard to write. Especially if you can give a list of the tables, and what columns need to be modified. Probably this would generally be a useful script to have for cases like this where databases are confidential, but need to be tuned by someone else. Would that be reasonable? I would think that by renaming columns, hashing the data in the columns, and renaming tables, most of the proprietary information is removed, without removing the database information. John =:-> --------------enigED29CEC84FC8E0FF9959219D Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (Cygwin) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCZr6wJdeBCYSNAAMRArWhAKC+MMmXfR4OKqJ2lSHVgFaXPN7R9ACeO2TR Fo8gSJav6PMJZBLzu/+vO+I= =LLOi -----END PGP SIGNATURE----- --------------enigED29CEC84FC8E0FF9959219D--