Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id A8663632520 for ; Wed, 21 Jan 2009 11:02:29 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 65843-03 for ; Wed, 21 Jan 2009 11:02:22 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from web52506.mail.re2.yahoo.com (web52506.mail.re2.yahoo.com [206.190.48.189]) by mail.postgresql.org (Postfix) with SMTP id E720C63256B for ; Wed, 21 Jan 2009 11:02:08 -0400 (AST) Received: (qmail 77578 invoked by uid 60001); 21 Jan 2009 15:02:06 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br; h=X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:MIME-Version:Content-Type:Message-ID; b=KsR8uX387JdENKCJFfDfAVKcQUniFBzKYcoFdTmOCQx9a55whF+1jEiuzLfGAYJulfHOOK/32TiR0XDLPOp6IMjpRGHvYa5QNiY0IjsvDpuOfHYNx67VlI5rIamCy7PgjJJX+VYx7eXZBV0DF0qU0XD/QNgeQTG2Hn1Mt3mKktQ=; X-YMail-OSG: SNktiOMVM1njOdc98jyb5GzzGsDf0wnvHfKgs7nj74THrbr3dXKhfoZ..9iN4FfLIzRY9QNKr4_8BVz_ILpSsCwMmgUZr4.tZcjGCVOpdGlZg5hltuQemrEbDRfidTUVeX.I5gK3IqntAJCPyde3luYKwIVQQZolmSJO9LCMzVlXcNz82PK9XPDY5PSH6X1GWKjO4FfDsWFdSdFi4bLSNxtq7lJhwOM- Received: from [189.17.249.3] by web52506.mail.re2.yahoo.com via HTTP; Wed, 21 Jan 2009 07:02:06 PST X-Mailer: YahooMailRC/1155.45 YahooMailWebService/0.7.260.1 References: <359812.4771.qm@web52512.mail.re2.yahoo.com> <2f4958ff0901210555y8b02b8dpa9db2b15873bf23a@mail.gmail.com> <20090121140623.GG14570@it.is.rice.edu> Date: Wed, 21 Jan 2009 07:02:06 -0800 (PST) From: paulo matadr Subject: Res: [GENERAL] bytea size limit? To: Kenneth Marshall , Grzegorz Ja??kiewicz Cc: pgsql-general@postgresql.org, admin MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-895950153-1232550126=:77018" Message-ID: <901365.77018.qm@web52506.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200901/87 X-Sequence-Number: 31134 --0-895950153-1232550126=:77018 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable My system have very large ram size, so its possible review postgresql.conf = ?=0A=0A=0A________________________________=0ADe: Kenneth Marshall =0APara: Grzegorz Ja??kiewicz =0ACc: paulo matadr <= saddoness@yahoo.com.br>; pgsql-general@postgresql.org; admin =0AEnviadas: Quarta-feira, 21 de Janeiro de 2009 11:06:23=0AA= ssunto: Re: [ADMIN] [GENERAL] bytea size limit?=0A=0AOn Wed, Jan 21, 2009 a= t 01:55:28PM +0000, Grzegorz Ja??kiewicz wrote:=0A> there's no real limit (= its size is described with 32bit number, and=0A> that's the only limitation= here).=0A> But you need to be aware, that content is sent over at once, so= memory=0A> is the limit in your case.=0A> =0A> http://www.postgresql.org/d= ocs/8.3/static/datatype-binary.html=0A> =0A> For such large objects, it mig= ht be actually better to store them=0A> separate as files, and just store f= ile name.=0A> =0A=0AThe TOAST implementation however only allows 30-bits fo= r the=0Asize of the TOAST entry which caps the size at 2^30 or 1GB. I=0Aagr= ee that he could very well be limited also by the memory on=0Ahis system.= =0A=0ACheers,=0AKen=0A=0A=0A=0A Veja quais s=C3=A3o os assuntos do mom= ento no Yahoo! +Buscados=0Ahttp://br.maisbuscados.yahoo.com --0-895950153-1232550126=:77018 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

My system have very large ram size, so its possible re= view postgresql.conf ?

= De: Kenneth Marshall <ktm@= rice.edu>
Para: Grze= gorz Ja??kiewicz <gryzman@gmail.com>
Cc: paulo matadr <saddoness@yahoo.com.br>; pgsql-= general@postgresql.org; admin <pgsql-admin@postgresql.org>
Enviadas: Quarta-feira, 21 de Jan= eiro de 2009 11:06:23
Assunto: Re: [ADMIN] [GENERAL] bytea size limit?

On Wed, Jan 21, 2009 at = 01:55:28PM +0000, Grzegorz Ja??kiewicz wrote:
> there's no real limit= (its size is described with 32bit number, and
> that's the only limi= tation here).
> But you need to be aware, that content is sent over a= t once, so memory
> is the limit in your case.
>
> http://www.postgresql.org/docs/8.3/static/datatype-binary.html=
>
> For such large objects, it might be actually better t= o store them
> separate as files, and just store file name.
> <= br>
The TOAST implementation however only allows 30-bits for the
size= of the TOAST entry which caps the size at 2^30 or 1GB. I
agree that he = could very well be limited also by the memory on
his system.

Chee= rs,
Ken

=0A=0A=0A

Veja quais = s=C3=A3o os assuntos do momento no Yahoo! + Buscados: Top 10<= /a> - Celebridades - M=C3=BAsica - Esportes --0-895950153-1232550126=:77018--