From: silly sad <sad@bankir.ru>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re:
Date: Mon, 05 Jul 2010 11:10:59 +0400
Message-ID: <4C318583.60306@bankir.ru> (raw)
In-Reply-To: <AANLkTili97Q6I-F-6R46h4a7JyAqog9zwX1SL08QNCC1@mail.gmail.com>
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>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sad@bankir.ru, pavel.stehule@gmail.com
Subject: Re:
In-Reply-To: <4C318583.60306@bankir.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox