From: Nelson Ferreira Junior <nelson@radix.com.br>
To: pgsql-interfaces@postgresql.org
Subject: Re: Large strings
Date: Mon, 17 Apr 2000 18:30:32 -0300
Message-ID: <38FB8278.63E4962D@radix.com.br> (raw)
References: <38FB6F90.17DD293A@radix.com.br>
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.
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-interfaces@postgresql.org
Cc: nelson@radix.com.br
Subject: Re: Large strings
In-Reply-To: <38FB8278.63E4962D@radix.com.br>
* 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