Message-ID: <38FB8278.63E4962D@radix.com.br>
Date: Mon, 17 Apr 2000 18:30:32 -0300
From: Nelson Ferreira Junior <nelson@radix.com.br>
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Re: Large strings
References: <38FB6F90.17DD293A@radix.com.br>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Nelson Ferreira Junior wrote:

>    Hi,
>
>    I have a JDBC aplication that actualy works with Oracle and I am
> porting it PostgreSQL. The trouble is that I have some rows with type
> "LONG" (in Oracle) where are stored strings with up to 20Kb and
> PostgreSQL doesn't hava this type and seems to be impossible to store
> strings larger than 8Kb with the types "TEXT" or "VARCHAR".
>    What can I do ?!?!
>
>                                                     thanks.

       Now I read something about changing the BLOCK SIZE to a higher
value and recompiling the backend. But it will require more disk space to
store the data, isn't it?  How much disk space will I need if a chage the
block size to 32K? Will it decrease performance or confiability ?
        Before you suggest me to use BLOBs to store these large strings,
I'd say that I cannot change my aplication in that way.


                                                             Thanks
again.