Envelope-to: pgsql-sql@postgresql.org
Message-ID: <4C318583.60306@bankir.ru>
Date: Mon, 05 Jul 2010 11:10:59 +0400
From: silly sad <sad@bankir.ru>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.5)
	Gecko/20100111 Thunderbird/3.0
MIME-Version: 1.0
To: Pavel Stehule <pavel.stehule@gmail.com>
CC: pgsql-sql@postgresql.org
Subject: Re: 
References: <AANLkTimLXJitQ9sPf0I-iDeRwtrWloLJbfGzE-E2hGif@mail.gmail.com>
	<4C3177B8.3080803@bankir.ru>
	<AANLkTikMUp9xLEYYT8rlXX30Q7Gl1IusxXnsTnwQvysz@mail.gmail.com>
	<4C317D82.7020702@bankir.ru>
	<AANLkTimdcnJjiW55hICUt9a-2HN4tyzETCuyvqb7hkzt@mail.gmail.com>
	<4C318226.3040701@bankir.ru>
	<AANLkTili97Q6I-F-6R46h4a7JyAqog9zwX1SL08QNCC1@mail.gmail.com>
In-Reply-To: <AANLkTili97Q6I-F-6R46h4a7JyAqog9zwX1SL08QNCC1@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

On 07/05/10 11:03, Pavel Stehule wrote:
> 2010/7/5 silly sad<sad@bankir.ru>:
>> On 07/05/10 10:43, Pavel Stehule wrote:
>>
>>> The good size for text or bytea is less than 100M and real max isn't
>>> 2G but it is 1G. LO isn't these limits because it isn't accessable on
>>> SQL level.
>>
>> any regular file on my filesystem isn't accessible on SQL level.
>> i am happy with them and never tried to store at a database.
>
> this is second extreme - you can use everything if you know what you
> do - and mainly it depends on applications and requests that you have
> to solve.

the trouble is the initiator of the thread didn't determine what is his 
problem either storing of a zero-byte containing string or storing of 
huge strings.
I answered him about BYTEA and he replied about BLOB.
I only tried to say i didn't say a word about BLOB.

P.S.
Practically for storing pictures i prefer regular files.