Re: max_allowed_packet equivalent in Postgres? - Mailing list pgsql-general

From Greg Stark
Subject Re: max_allowed_packet equivalent in Postgres?
Date
Msg-id 407d949e0908131835w3dc7b936oa4be8cabdaa62416@mail.gmail.com
Whole thread Raw
In response to Re: max_allowed_packet equivalent in Postgres?  (Sam Mason <sam@samason.me.uk>)
List pgsql-general
On Fri, Aug 14, 2009 at 12:33 AM, Sam Mason<sam@samason.me.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@samason.me.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

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: PostgreSQL for Firefox Bookmarks?
Next
From: "Ow Mun Heng"
Date:
Subject: Re: mail alert