Re: max_allowed_packet equivalent in Postgres?

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Sam Mason <sam(at)samason(dot)me(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: max_allowed_packet equivalent in Postgres?
Date: 2009-08-14 01:35:22
Message-ID: 407d949e0908131835w3dc7b936oa4be8cabdaa62416@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Aug 14, 2009 at 12:33 AM, Sam Mason<sam(at)samason(dot)me(dot)uk> wrote:
> On Fri, Aug 14, 2009 at 12:03:37AM +0100, Greg Stark wrote:
>> On Thu, Aug 13, 2009 at 11:20 PM, Sam Mason<sam(at)samason(dot)me(dot)uk> wrote:

>> > There would be no way of creating a row 1.6TB in size in one go
>....
> I was thinking of a single update per column.

Oh, my bad, you did indeed say "row" and I assumed column. Yes, you
could create a single row of 1.6TB by doing repeated updates setting
one column at a time to a 1G datum. (You would have to be using 32k
blocks though)

--
greg
http://mit.edu/~gsstark/resume.pdf

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ow Mun Heng 2009-08-14 01:52:02 Re: mail alert
Previous Message Sam Mason 2009-08-13 23:45:27 Re: comparing NEW and OLD (any good this way?)