Re: large tuple - Mailing list pgsql-general

From Kenneth Been
Subject Re: large tuple
Date
Msg-id 3A23FB1B.15A5F690@telocity.com
Whole thread Raw
In response to large tuple  (Kenneth Been <kennethb@telocity.com>)
Responses Re: large tuple  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: "Joel Burton"
Date:
Subject: Re: Warning: Don't delete those /tmp/.PGSQL.* files
Next
From: Tom Lane
Date:
Subject: Re: large tuple