Skip site navigation (1) Skip section navigation (2)

Re: Large strings

From: Nelson Ferreira Junior <nelson(at)radix(dot)com(dot)br>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Large strings
Date: 2000-04-19 14:53:17
Message-ID: 38FDC85C.F11F51EA@radix.com.br (view raw or flat)
Thread:
Lists: pgsql-interfaces
     I reinstalled Postgre with page size set to 32K, but it still doesn't
work. I got the following errors. Is it complaining abou the size of the
query itself ?

* Java program (even using a prepared statement)
     SQLException: The SQL Statement is too long
* Puting the query in a file and calling with psql -f :
     ERROR:  Tuple is too big: size 11424, max size 8140

                                                             Thanks


Peter Mount wrote:

> The page size is only really the size of disk allocated each time. You
> can get many rows into a page.
>
> As you said you can't use LO's, perhaps the page size is your only
> chance (although I'm not sure if the text/varchar types are hardcoded to
> a max 4k anyhow.
>
> Peter
>
> --
> Peter Mount
> Enterprise Support
> Maidstone Borough Council
> Any views stated are my own, and not those of Maidstone Borough Council.
>
> -----Original Message-----
> From: Nelson Ferreira Junior [mailto:nelson(at)radix(dot)com(dot)br]
> Sent: Monday, April 17, 2000 10:31 PM
> To: pgsql-interfaces(at)postgresql(dot)org
> Subject: Re: [INTERFACES] Large strings
>
> 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.


In response to

Responses

pgsql-interfaces by date

Next:From: Dwelle, TimothyDate: 2000-04-19 15:06:44
Subject: RE: JDBC: Missing Classes?
Previous:From: Tom LaneDate: 2000-04-19 13:54:33
Subject: Re: getting OID of INSERTed record in ECPG

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group