Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eNCxr-0002kO-N6 for pgsql-performance@arkaria.postgresql.org; Fri, 08 Dec 2017 07:20:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eNCxp-000472-LZ for pgsql-performance@arkaria.postgresql.org; Fri, 08 Dec 2017 07:20:53 +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_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eNCxp-00046t-Ep for pgsql-performance@lists.postgresql.org; Fri, 08 Dec 2017 07:20:53 +0000 Received: from mail.i-mark.de ([188.138.104.222]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eNCxi-0001xd-6W for pgsql-performance@lists.postgresql.org; Fri, 08 Dec 2017 07:20:52 +0000 Received: from [172.29.5.29] (ip4d176092.dynamic.kabel-deutschland.de [77.23.96.146]) by mail.i-mark.de (Postfix) with ESMTPSA id 636BC1581AB5 for ; Fri, 8 Dec 2017 08:20:39 +0100 (CET) Subject: Re: Table with large number of int columns, very slow COPY FROM To: pgsql-performance@lists.postgresql.org References: From: Andreas Kretschmer Message-ID: <817fe5f2-c15e-4369-15ce-1e26f74bbbca@a-kretschmer.de> Date: Fri, 8 Dec 2017 08:20:40 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.5.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=windows-1252; 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 08.12.2017 05:21, Alex Tokarev wrote: > I have made a minimally reproducible test case consisting of a table > with 848 columns Such a high number of columns is maybe a sign of a wrong table / database design, why do you have such a lot of columns? How many indexes do you have? Regards, Andreas