Re: 8Ko limitation

Hello Karel

On Jul 20, 10:00am, Karel Zak wrote:
> Subject: Re: [HACKERS] 8Ko limitation
>
> > what about performances with postgreSQL and large databases,
> > the object size limitation (8192 bytes) is really not acceptable for
this
>
> Now you can change this limit in config.h, the possible range is
> 8Kb - 32Kb.
>
> In new 7.1 version will this limit dead forever (see TOAST project).

We use Postgres to store polygons and I asked this same question before. The
reply I got was that the geometric data types were not guaranteed to be
converted to TOASTable data types (they were at the bottom of the list of types
to convert). They hinted that I could help them with this but I have no time.
Has this changed now? Will the geometric data types be TOASTable for 7.1?

--
Sincerely,

Jazzman (a.k.a. Justin Hickey) e-mail: jhickey(at)hpcc(dot)nectec(dot)or(dot)th
High Performance Computing Center
National Electronics and Computer Technology Center (NECTEC)
Bangkok, Thailand
==================================================================
People who think they know everything are very irritating to those
of us who do. ---Anonymous

Jazz and Trek Rule!!!
==================================================================