From joseph.pravato@nomagic.com Mon Mar 4 21:32:12 2013 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-- From vyegorov@gmail.com Mon Mar 4 21:37:27 2013 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UCd4Z-0006Ah-Lf for pgsql-performance@arkaria.postgresql.org; Mon, 04 Mar 2013 21:37:27 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UCd4Z-0007pI-2A for pgsql-performance@arkaria.postgresql.org; Mon, 04 Mar 2013 21:37:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UCd4Y-0007p7-7k for pgsql-performance@postgresql.org; Mon, 04 Mar 2013 21:37:26 +0000 Received: from mail-we0-x231.google.com ([2a00:1450:400c:c03::231]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UCd4V-00007p-Uq for pgsql-performance@postgresql.org; Mon, 04 Mar 2013 21:37:25 +0000 Received: by mail-we0-f177.google.com with SMTP id d7so4998786wer.36 for ; Mon, 04 Mar 2013 13:37:22 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:in-reply-to:references:date:message-id :subject:from:to:cc:content-type; bh=/BUTsZC+LRSJAVNq3Q7efZDZVrv2vVIBag+m+M9oIeg=; b=hJapLS8ytLz88DfPZ7+FH0KBqIK+4voRuge0Vw9zIMQpeFxks4KjctrPTxK6/YllhA zOkBrbHstzLTzQSCw8MdcRiFrkZ1l8CTbCzBadge90e4PSzoy4Py3sJNEb3SSlWUwGOV usfkpnSVIiTMhrzSiIW7qqURANH3d5gZNgvy7RCfFnTWHLPGG73rYkEpWalgOwWBULC0 3IanxTTIhFphQDC78IV1Y4F8rTWv7fS5/akUM9BdzWMeNhA80FhmYwZTsu5d5UGdCCdO OKjFYLcJVhF0T8D6EUkbr2oIceJbFvwdZllc8Tc94AzG8qIlQTcNBSInEspnbP9pp31k L/2g== MIME-Version: 1.0 X-Received: by 10.180.183.81 with SMTP id ek17mr6304561wic.2.1362433042349; Mon, 04 Mar 2013 13:37:22 -0800 (PST) Received: by 10.181.13.109 with HTTP; Mon, 4 Mar 2013 13:37:22 -0800 (PST) In-Reply-To: <513512BE.5070007@nomagic.com> References: <513512BE.5070007@nomagic.com> Date: Mon, 4 Mar 2013 23:37:22 +0200 Message-ID: Subject: Re: Schema obfuscator for performance question From: Victor Yegorov To: Joseph Pravato Cc: pgsql-performance@postgresql.org Content-Type: multipart/alternative; boundary=001a11c34dc085086e04d72029df X-Pg-Spam-Score: -2.0 (--) 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 --001a11c34dc085086e04d72029df Content-Type: text/plain; charset=UTF-8 2013/3/4 Joseph Pravato > 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? > You can anonymize EXPLAIN output here: http://explain.depesz.com/ Not sure bout the schema... -- Victor Y. Yegorov --001a11c34dc085086e04d72029df Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 2013/3/4 Joseph Pravato <joseph.pravato@nomagic.com>
=20 =20 =20
=20

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?


You can a= nonymize EXPLAIN output here: http:/= /explain.depesz.com/

Not sure bout the schema.= ..=C2=A0


--
Victor Y. Yegorov --001a11c34dc085086e04d72029df-- From klaussfreire@gmail.com Mon Mar 4 21:37:28 2013 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UCd4a-0006An-AY for pgsql-performance@arkaria.postgresql.org; Mon, 04 Mar 2013 21:37:28 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UCd4Z-0007ph-PT for pgsql-performance@arkaria.postgresql.org; Mon, 04 Mar 2013 21:37:27 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UCd4Y-0007p8-8k for pgsql-performance@postgresql.org; Mon, 04 Mar 2013 21:37:26 +0000 Received: from mail-wg0-f48.google.com ([74.125.82.48]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UCd4W-0007Aj-WF for pgsql-performance@postgresql.org; Mon, 04 Mar 2013 21:37:25 +0000 Received: by mail-wg0-f48.google.com with SMTP id 16so4675002wgi.27 for ; Mon, 04 Mar 2013 13:37:23 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:in-reply-to:references:date:message-id :subject:from:to:cc:content-type; bh=QPOaOMW8kJf/qrTyBIHuarI8z/UVRbr4zEzrwZ2EpfY=; b=jgg0qaL0m0KvbKKiRw0rHbX5ttr2s6NxFzsMJY0hfLWEBufvpKetIYeWlWqga+Wyuk FfdSdNKGxolltJ5i6z6xPs7/GtxavrwezLXSlf5ZwNAzqIVl0ZeAeSZFtzA37agBPscx YtMDN9CSR7FLXmx0Cnch+2TxmQkyIJvsH7pAT0/62JmN7DMDuDax4LD1LXi2a3LhfgmC RG8uoPse1HOEZdaDPFv9gkZfLlftFsVhTRl2fAZruh1kSSMnQTgccWrRZrMvDc9Sv8JC DNuJc6m999OdAowxGcfhtyltXja5yA6hR39CW2OAqU5w2ik2QeuUg9JbwhFqmJyje4io nHWQ== MIME-Version: 1.0 X-Received: by 10.194.120.169 with SMTP id ld9mr34860910wjb.24.1362433043739; Mon, 04 Mar 2013 13:37:23 -0800 (PST) Received: by 10.180.19.33 with HTTP; Mon, 4 Mar 2013 13:37:23 -0800 (PST) In-Reply-To: <513512BE.5070007@nomagic.com> References: <513512BE.5070007@nomagic.com> Date: Mon, 4 Mar 2013 18:37:23 -0300 Message-ID: Subject: Re: Schema obfuscator for performance question From: Claudio Freire To: Joseph Pravato Cc: postgres performance list Content-Type: text/plain; charset=ISO-8859-1 X-Pg-Spam-Score: -2.6 (--) 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 On Mon, Mar 4, 2013 at 6:31 PM, Joseph Pravato wrote: > 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! Without getting into the ugly business of asking why you'd want to obfuscate schema, I can imagine a few (wrong) answers, I'll start by noting that schema transmits meaning in the very names used, so obfuscation, especially automatic and mindless obfuscation, will make the problem a lot harder to review, because it will be a lot harder to understand the schema. So... I'd suggest, if you need obfuscation, that it should be done manually, so that you may preserve meaningful names. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance