Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hSpxy-0006uT-H9 for pgsql-general@arkaria.postgresql.org; Mon, 20 May 2019 21:37:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hSpxw-0007U5-R1 for pgsql-general@arkaria.postgresql.org; Mon, 20 May 2019 21:37:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hSpxw-0007Ty-FK for pgsql-general@lists.postgresql.org; Mon, 20 May 2019 21:37:04 +0000 Received: from mail-ot1-x341.google.com ([2607:f8b0:4864:20::341]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hSpxt-0001mv-P8 for pgsql-general@lists.postgresql.org; Mon, 20 May 2019 21:37:03 +0000 Received: by mail-ot1-x341.google.com with SMTP id r7so14413173otn.6 for ; Mon, 20 May 2019 14:37:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding:content-language; bh=IJdB1A1ubLqh+VpcHuJOLT8UUBjukqadQFKknChLRlg=; b=tlYbV44bmirH0aPtsIGhEB7SJYcDsbpwC04W21VG1T+bNTfXi8t2SQTgS+SlW6w0IH QNP42Ms/8vNwmfpn80Awow2xLsKtdMlFGZGz8TIBIvAz9YJ+5G2Rmrl5//UT/oq7PFX+ FkUNLakqoPRxRnqhLR2Okp6TeCapRtumlTOoczgu8lTR3htII67RsAopA9Y2UNY+fTI2 iFqp1Wg3lTfzJJInzMLiu/Y+DyeHl0B2ghxti4i7erlB9sy8PjuuWCLV0Oju/IFc+Ntj jOTvMiDcpFNBJ/PqwGddn1Cqu7PG/ihK5P9jfH7XPpc+oXYD13bNsUtt3Ie/W+oxhFfd 56cg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=IJdB1A1ubLqh+VpcHuJOLT8UUBjukqadQFKknChLRlg=; b=BoUEgYAlrLUlfdpX5rLzxXsErOAaLLY0R9AF/kSzBGCx70YXU31YFflW7IkixtAK7X yqFAiEoYFaz7ESjJaInDfo3G4h5il8ax/26AzjbcXntsb7+QX4WmAGG6DQEbe6ePvP6D 2BeJOhThlb3I6Kg3r4z60DifB2qwlHdk/8sZnazDE2S3b9SnvFdy2GKu6sI+9GDtNZ2b sfZAU0EvpRgrhQoMxg5qD10+gPFaigeehVANm29drs7U8uZKgAyXTVXIYbNKVmKpEVIu spCOjAfZJ6p8l6eCjC1l6RJ+dk+y9tiec8mvAtgOuaa/aWTA1367IAMu8XDoH0xSsnBP dHZQ== X-Gm-Message-State: APjAAAX4hVhe0RGRYUZ0qpy+b12eaZO9wYSjDvvCQ7HwntcTcnf8Kt7+ T/9/6MTN6bWJT6YOcX4ivzWUbXssjET18Q== X-Google-Smtp-Source: APXvYqxYWFRFwVXG57EY1rcPOAxieb2BdvAfEOPiiRpqWpwzEeikbf1DUb4uU/Nr++R8ML61ynPK/w== X-Received: by 2002:a9d:4d0d:: with SMTP id n13mr46976208otf.314.1558388219502; Mon, 20 May 2019 14:36:59 -0700 (PDT) Received: from [192.168.1.10] (ip70-171-116-89.no.no.cox.net. [70.171.116.89]) by smtp.googlemail.com with ESMTPSA id p12sm6455809otq.57.2019.05.20.14.36.58 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 20 May 2019 14:36:58 -0700 (PDT) Subject: Re: Loading table with indexed jsonb field is stalling To: pgsql-general@lists.postgresql.org References: <20505.1558202555@sss.pgh.pa.us> <90835D2B-1FBA-4F26-8157-7C831C24B266@gmail.com> <3A35A039-D8F5-4B40-9B41-42E70BEF2C2E@gmail.com> From: Ron Message-ID: <806d4915-f05d-8e75-0a42-e11b48596ab5@gmail.com> Date: Mon, 20 May 2019 16:36:58 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.6.1 MIME-Version: 1.0 In-Reply-To: <3A35A039-D8F5-4B40-9B41-42E70BEF2C2E@gmail.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 5/20/19 4:14 PM, Will Hartung wrote: [snip] > Also to note, I tried just loading the table with no indexes, and I was > getting a solid 22MB/s via iostat of just raw data load (just to proof > that I/O system, while certainly not extraordinary, was functional). I think you answered this earlier, but does the same stalling happen when indexes are dropped? -- Angular momentum makes the world go 'round.