Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aasBV-0002x9-VG for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Mar 2016 21:50:26 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aasBV-0000NB-IH for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Mar 2016 21:50:25 +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) (envelope-from ) id 1aasAA-0007Ej-KY for pgsql-hackers@postgresql.org; Tue, 01 Mar 2016 21:49:02 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aasA7-0002nT-MT for pgsql-hackers@postgresql.org; Tue, 01 Mar 2016 21:49:01 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id u21Lmha1027429; Tue, 1 Mar 2016 16:48:43 -0500 From: Tom Lane To: "Daniel Verite" cc: "Alvaro Herrera" , "Robert Haas" , "Jim Nasby" , "Ronan Dunklau" , "pgsql-hackers" Subject: Re: pg_dump / copy bugs with "big lines" ? In-reply-to: <149c79ee-9f41-48e1-83f8-3b2fe90af2b6@mm> References: <149c79ee-9f41-48e1-83f8-3b2fe90af2b6@mm> Comments: In-reply-to "Daniel Verite" message dated "Tue, 01 Mar 2016 22:31:19 +0100" Date: Tue, 01 Mar 2016 16:48:43 -0500 Message-ID: <27428.1456868923@sss.pgh.pa.us> X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org "Daniel Verite" writes: > I've tried adding another large field to see what happens if the whole row > exceeds 2GB, and data goes to the client rather than to a file. > My idea was to check if the client side was OK with that much data on > a single COPY row, but it turns out that the server is not OK anyway. BTW, is anyone checking the other side of this, ie "COPY IN" with equally wide rows? There doesn't seem to be a lot of value in supporting dump if you can't reload ... regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers