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

Re: var size too small?

From: Jason Earl <jason(dot)earl(at)simplot(dot)com>
To: Adam Bultman <adam(dot)bultman(at)iconideas(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: var size too small?
Date: 2001-11-09 17:32:43
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
What version of PostgreSQL.  Before 7.1 PostgreSQL had a row limit of
8K.  This could be increased to 32K, but only by recompiling
PostgreSQL.  Newer versions don't have this limitation.


Adam Bultman <adam(dot)bultman(at)iconideas(dot)com> writes:

> Hey everyone. I'm a bit of a lurker, but I've got a question:
> We've got a database with a table with items of type "var" in them, and
> it seems that it's not unlimited, but rather, about 8k.  Is there a way
> to fix this without switching to a recent beta version? Is there a work
> around?
> --
> Adam Bultman
> Icon Multimedia
> 616-836-7213
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?

In response to

pgsql-novice by date

Next:From: Isaac SparrowDate: 2001-11-09 17:57:19
Subject: Re:
Previous:From: Jason EarlDate: 2001-11-09 17:30:47
Subject: Re: Benchmarking

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