Received: from bastuba.partitur.se (bastuba.partitur.se [193.219.246.194]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA39387 for ; Fri, 21 Jan 2000 10:05:55 -0500 (EST) (envelope-from kudo@partitur.se) Received: from partitur.se (tb303.partitur.se [193.219.246.230]) by bastuba.partitur.se (8.8.8/8.8.8) with ESMTP id QAA26886 for ; Fri, 21 Jan 2000 16:05:53 +0100 (CET) (envelope-from kudo@partitur.se) Sender: kudo@partitur.se Message-ID: <388875D0.21942465@partitur.se> Date: Fri, 21 Jan 2000 16:05:52 +0100 From: Patrik Kudo Organization: Partitur Informationsteknik X-Mailer: Mozilla 4.7 [en] (X11; I; FreeBSD 3.3-RELEASE i386) X-Accept-Language: sv,en MIME-Version: 1.0 To: "pgsql-sql@postgreSQL.org" Subject: Problem with large tuples. Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I've noticed that some of my tables with large text tuples have problem when these exceed some certain size. I know about the 8k tuplesize limit, but it seems the problem appears earlier than that. This is what I've been able to recreate: CREATE TABLE sizetest (id int, txt text); INSERT INTO sizetest (id, txt) VALUES (1, '...'); // ... = string of 4000 chars vacuum analyze; // <-- works nicely INSERT INTO sizetest (id, txt) VALUES (2, '...'); // ... = string of 4100 chars vacuum analyze; ERROR: Tuple is too big: size 8152, max size 8140 How come the insert works while the vacuum fails? Setup: Postgres 6.5.2, FreeBSD 3.3 /Patrik Kudo