Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UCczU-0005pc-M3 for pgsql-performance@arkaria.postgresql.org; Mon, 04 Mar 2013 21:32:12 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UCczU-0005k4-2b for pgsql-performance@arkaria.postgresql.org; Mon, 04 Mar 2013 21:32:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UCczS-0005jy-Qa for pgsql-performance@postgresql.org; Mon, 04 Mar 2013 21:32:10 +0000 Received: from smtp.cameosuite.com ([12.208.99.107] helo=nomagic.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UCczP-0008U6-Qg for pgsql-performance@postgresql.org; Mon, 04 Mar 2013 21:32:10 +0000 Received: from [10.91.55.186] (allen.nomagic.com [12.208.99.2]) by nomagic.com (Postfix) with ESMTP id 9763987EAA for ; Mon, 4 Mar 2013 15:32:05 -0600 (CST) Message-ID: <513512BE.5070007@nomagic.com> Date: Mon, 04 Mar 2013 15:31:42 -0600 From: Joseph Pravato User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20130215 Thunderbird/17.0.3 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Schema obfuscator for performance question X-Enigmail-Version: 1.5 Content-Type: multipart/alternative; boundary="------------050602030008030500040608" X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org This is a multi-part message in MIME format. --------------050602030008030500040608 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Good Afternoon, We are having a performance issue with our views in PostgreSQL and based on the requirements for assistance you recommend providing the full table and index schema besides additional information from this site. https://wiki.postgresql.org/wiki/Slow_Query_Questions We have been unsuccessful in finding a tool to obfuscate the schema before providing it for review, is there an open source tool you recommend to use? Thanks! --------------050602030008030500040608 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit

Good Afternoon,

We are having a performance issue with our views in PostgreSQL and based on the requirements for assistance you recommend providing the full table and index schema besides additional information from this site. https://wiki.postgresql.org/wiki/Slow_Query_Questions

We have been unsuccessful in finding a tool to obfuscate the schema before providing it for review, is there an open source tool you recommend to use?

Thanks!

--------------050602030008030500040608--