Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id E012A200C23 for ; Wed, 22 Feb 2017 23:11:03 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id DCAF7160B75; Wed, 22 Feb 2017 22:11:03 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 037FB160B49 for ; Wed, 22 Feb 2017 23:11:02 +0100 (CET) Received: (qmail 87096 invoked by uid 500); 22 Feb 2017 22:11:02 -0000 Mailing-List: contact commits-help@hawq.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hawq.incubator.apache.org Delivered-To: mailing list commits@hawq.incubator.apache.org Received: (qmail 87087 invoked by uid 99); 22 Feb 2017 22:11:02 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Feb 2017 22:11:02 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id C177518E16A for ; Wed, 22 Feb 2017 22:11:01 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -6.218 X-Spam-Level: X-Spam-Status: No, score=-6.218 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_DNSWL_HI=-5, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RP_MATCHES_RCVD=-2.999, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id kgyicDRypqwp for ; Wed, 22 Feb 2017 22:11:00 +0000 (UTC) Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with SMTP id EBFF861E2B for ; Wed, 22 Feb 2017 22:10:57 +0000 (UTC) Received: (qmail 86433 invoked by uid 99); 22 Feb 2017 22:10:56 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Feb 2017 22:10:56 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id ECE08DFF13; Wed, 22 Feb 2017 22:10:55 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: yozie@apache.org To: commits@hawq.incubator.apache.org Date: Wed, 22 Feb 2017 22:11:06 -0000 Message-Id: In-Reply-To: References: X-Mailer: ASF-Git Admin Mailer Subject: [12/18] incubator-hawq-docs git commit: HAWQ-1293 - identify/tag deprecated gucs (closes #91) archived-at: Wed, 22 Feb 2017 22:11:04 -0000 HAWQ-1293 - identify/tag deprecated gucs (closes #91) Project: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/commit/ab49891f Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/tree/ab49891f Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/diff/ab49891f Branch: refs/heads/release/2.1.0.0-incubating Commit: ab49891f412c631ba350b9632b73c49ef69aa8d2 Parents: dcfe1a4 Author: Lisa Owen Authored: Thu Feb 9 08:48:32 2017 -0800 Committer: David Yozie Committed: Thu Feb 9 08:48:37 2017 -0800 ---------------------------------------------------------------------- markdown/query/query-profiling.html.md.erb | 5 ++--- markdown/reference/guc/parameter_definitions.html.md.erb | 4 +++- 2 files changed, 5 insertions(+), 4 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/ab49891f/markdown/query/query-profiling.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/query/query-profiling.html.md.erb b/markdown/query/query-profiling.html.md.erb index fccef18..00fffe6 100644 --- a/markdown/query/query-profiling.html.md.erb +++ b/markdown/query/query-profiling.html.md.erb @@ -107,8 +107,7 @@ The estimated startup cost for this plan is `00.00` (no cost) and a total cost o Work_mem wanted: 90K bytes avg, 90K byes max (seg0) to lessen workfile I/O affecting 2 workers. ``` -**Note** -The *work\_mem* property is not configurable. Use resource queues to manage memory use. For more information on resource queues, see [Configuring Resource Management](../resourcemgmt/ConfigureResourceManagement.html) and [Working with Hierarchical Resource Queues](../resourcemgmt/ResourceQueues.html). +**Warning**: The `work_mem` server configuration parameter is deprecated and will be removed in a future HAWQ release. Use resource queues to manage memory use. For more information on resource queues, see [Configuring Resource Management](../resourcemgmt/ConfigureResourceManagement.html) and [Working with Hierarchical Resource Queues](../resourcemgmt/ResourceQueues.html). - The time (in milliseconds) in which the segment that produced the most rows retrieved the first row, and the time taken for that segment to retrieve all rows. The result may omit *<time> to first row* if it is the same as the *<time> to end*. @@ -162,7 +161,7 @@ If a query performs poorly, examine its query plan and ask the following questio `Work_mem used: 23430K bytes avg, 23430K bytes max (seg0). Work_mem wanted: 33649K bytes avg, 33649K bytes max (seg0) to lessen workfile I/O affecting 2 workers.` - The "bytes wanted" message from `EXPLAIN ANALYZE` is based on the amount of data written to work files and is not exact. The minimum `work_mem` needed can differ from the suggested value. + The "bytes wanted" message from `EXPLAIN ANALYZE` is based on the amount of data written to work files and is not exact. The minimum `work_mem` needed can differ from the suggested value. ## Generating EXPLAIN Plan from a PL/pgSQL Function http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/ab49891f/markdown/reference/guc/parameter_definitions.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/guc/parameter_definitions.html.md.erb b/markdown/reference/guc/parameter_definitions.html.md.erb index 6d88075..a389f51 100644 --- a/markdown/reference/guc/parameter_definitions.html.md.erb +++ b/markdown/reference/guc/parameter_definitions.html.md.erb @@ -1508,10 +1508,12 @@ Sets the amount of data per-peer to be queued by the UDP interconnect on receive ## gp\_interconnect\_setup\_timeout -When the interconnect type is UDP, the time to wait for the Interconnect to complete setup before it times out. +When the interconnect type is UDP, the time to wait for the Interconnect to complete setup before it times out. This parameter is used only when [gp\_interconnect\_type](#gp_interconnect_type) is set to UDP. +**Warning**: The `gp_interconnect_setup_timeout` server configuration parameter is deprecated and will be removed in a future HAWQ release. + | Value Range | Default | Set Classifications | |---------------------------------------------|---------|-------------------------| | Any valid time expression (number and unit) | 2 hours | master, session, reload |