Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bAGBh-0002jh-6C for pgsql-performance@arkaria.postgresql.org; Tue, 07 Jun 2016 12:32:53 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bAGBg-0007CW-Kq for pgsql-performance@arkaria.postgresql.org; Tue, 07 Jun 2016 12:32:52 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bAGA1-0004i2-1o for pgsql-performance@postgresql.org; Tue, 07 Jun 2016 12:31:09 +0000 Received: from mail-oi0-x22b.google.com ([2607:f8b0:4003:c06::22b]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bAG9y-00030I-Fo for pgsql-performance@postgresql.org; Tue, 07 Jun 2016 12:31:07 +0000 Received: by mail-oi0-x22b.google.com with SMTP id e72so273612358oib.1 for ; Tue, 07 Jun 2016 05:31:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=nGG0lAOlbJy4vU5OFhaTo7yW/CC5Erx0ocrwSWF/wcc=; b=zjo2vX9BteafBZgQups8VuKUcKY8clpuhox3G5z5wgAhN3QuoUQw1BZEet4X/FQWXi 8nUmkJXi2u/OBFQJNrDm8DKYnkOeZbLsS1Cr2hwJgyS0tHiztAtERpbEINS3RkxUbLxI sLxbnN6OqqfT7VmwSTo3udl6qllFhFGDcniap9m0x6hFbgrod6cQJymKOyymt4OvZQp0 EbgQsD3YXOzfTrbnwayVWjkmr3sqHJw81KfkpvF0OH5vrsOV/i4wbCw2y+w03m1hzH+V mMTUp/xbImJCJnc1eOnheD7Nq+ZEu2hgeEoLNCGr4K30ZKYm7hHLMcr77eR/WHYBuyqI jmVg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=nGG0lAOlbJy4vU5OFhaTo7yW/CC5Erx0ocrwSWF/wcc=; b=VHa3PFHcfmBjbGSjtITjRl7XlMQ4xsxrKY1M2N06yjSRdwqLDlEcZUnKx7WfRfNi5u P8JcsSNPxcHETKAvd6s4nr3+5KpKgSUarPAMMT6Tc49hmPN0vrj+euLZMyxZrz4Uz1te y9UlUmRfZp4K6CdjlOZkrQh2rmZ4BWUG3qwo9+LImLdoIQxvqE1E91MW4wkcJSmTROKM IB9oScKOccDein1zHZbIr4dl1AqaFGIM8GDD7WfsK/xjE4UXbowXIirOOiaShqBNVMaM VmnWwmzqKizYPoGy7Apr+0q/abpYzggt+8tKfPK/rFB3fW6Jw0vAqmaWWgQrtbOzPkON W/Iw== X-Gm-Message-State: ALyK8tIK7fv/FQ8hw6ZcPZKAZfT1G+I05gsX5UXeGssjOOt/fYhjJKHz8W++ORaPWHKkNLWJcCnVqrnBijzDMg== X-Received: by 10.157.23.209 with SMTP id j75mr7437957otj.109.1465302665856; Tue, 07 Jun 2016 05:31:05 -0700 (PDT) MIME-Version: 1.0 Received: by 10.157.34.104 with HTTP; Tue, 7 Jun 2016 05:31:05 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Tue, 7 Jun 2016 08:31:05 -0400 Message-ID: Subject: Re: array size exceeds the maximum allowed (1073741823) when building a json To: Nicolas Paris Cc: pgsql-performance Content-Type: multipart/alternative; boundary=94eb2c0944f6e30ced0534af5c8e X-Pg-Spam-Score: -2.7 (--) 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 --94eb2c0944f6e30ced0534af5c8e Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable On Tue, Jun 7, 2016 at 7:44 AM, Nicolas Paris wrote: > Hello, > > I run a query transforming huge tables to a json document based on a peri= od. > It works great for a modest period (little dataset). > However, when increasing the period (huge dataset) I get this error: > > SQL ERROR[54000] > ERROR: array size exceeds the maximum allowed (1073741823) > > =E2=80=8Bhttps://www.postgresql.org/about/=E2=80=8B =E2=80=8BMaximum Field Size: 1 GB=E2=80=8B =E2=80=8BIt doesn't matter that the data never actually is placed into a ph= ysical table. David J. --94eb2c0944f6e30ced0534af5c8e Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
On Tue, Ju= n 7, 2016 at 7:44 AM, Nicolas Paris <niparisco@gmail.com> wrote:
Hello,

I run a =
query transforming huge tables to a json document based on a period.
It =
works great for a modest period (little dataset). 
However, when increas=
ing the period (huge dataset) I get this error:
=
SQL ERROR[54000]
ERROR: array size exceeds the=
 maximum allowed (1073741823)

=

= =E2=80=8BMaximum Field Size: 1 GB=E2=80=8B

=E2=80=8BIt doesn't matter that the data never= actually is placed into a physical table.

David J.

--94eb2c0944f6e30ced0534af5c8e--