Postgres Pro
Downloads
Home   >   mailing lists

Thread: large tuple

large tuple

From
Kenneth Been
Date:
I set BLCKSZ to 32768, as described in FAQ question 4.6,
recompiled and reinstalled the system, and ran initdb, and I
am still getting the error "Tuple is too big: size 9588, max
size 8140".

I am using 7.0.2 on a modified RedHat 6.0 (with glibc
upgraded to 2.1.3).

Any ideas why that would be?  Is there also something else I
need to do?

Is there a way to check at runtime what BLCKSZ the system is
using?

Thank you.

Ken

p.s. Sorry if this is a repeat of a previous message that I
hadn't thought was delivered properly.

Re: large tuple

From
Kenneth Been
Date:
Well, I solved this problem by doing two things:

1. I used 16384 instead of 32768.  I can't imagine this made
any difference.

2. I ran "make clean" before running "make".  Maybe there is
a problem with the dependencies in the makefiles?

Ken

Kenneth Been wrote:
>
> I set BLCKSZ to 32768, as described in FAQ question 4.6,
> recompiled and reinstalled the system, and ran initdb, and I
> am still getting the error "Tuple is too big: size 9588, max
> size 8140".
>
> I am using 7.0.2 on a modified RedHat 6.0 (with glibc
> upgraded to 2.1.3).
>
> Any ideas why that would be?  Is there also something else I
> need to do?
>
> Is there a way to check at runtime what BLCKSZ the system is
> using?
>
> Thank you.
>
> Ken
>
> p.s. Sorry if this is a repeat of a previous message that I
> hadn't thought was delivered properly.

Re: large tuple

From
Tom Lane
Date:
Kenneth Been <kennethb@telocity.com> writes:
> 2. I ran "make clean" before running "make".  Maybe there is
> a problem with the dependencies in the makefiles?

There are no dependencies in the Makefiles, unless you did "make
depend".  "make clean" is usually necessary after changing any
widely-used header file...

            regards, tom lane