Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 86808 invoked from network); 14 Mar 2007 14:35:21 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 14 Mar 2007 14:35:21 -0000 Received: (qmail 20534 invoked by uid 500); 14 Mar 2007 14:35:28 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 20505 invoked by uid 500); 14 Mar 2007 14:35:28 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 20491 invoked by uid 99); 14 Mar 2007 14:35:28 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 14 Mar 2007 07:35:28 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (herse.apache.org: local policy) Received: from [129.241.7.61] (HELO merke.itea.ntnu.no) (129.241.7.61) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 14 Mar 2007 07:35:15 -0700 Received: from localhost (localhost [127.0.0.1]) by merke.itea.ntnu.no (Postfix) with ESMTP id 165B213C884; Wed, 14 Mar 2007 15:34:54 +0100 (CET) Received: from trapper.coreless.net (trapper.fa-s.ntnu.no [129.241.43.241]) by merke.itea.ntnu.no (Postfix) with ESMTP; Wed, 14 Mar 2007 15:34:53 +0100 (CET) Received: from andersmo by trapper.coreless.net with local (Exim 4.63) (envelope-from ) id 1HRUZ3-0007q7-Oe; Wed, 14 Mar 2007 15:34:53 +0100 Date: Wed, 14 Mar 2007 15:34:53 +0100 From: Anders Morken To: Derby Discussion , f.barachant@monnaie-services.com Subject: Re: out of memory when writing blobs Message-ID: <20070314143453.GN3557@trapper.coreless.net> Reply-To: derby-user@db.apache.org References: <45F6DB94.1080000@free.fr> <45F7B4EB.6000100@free.fr> <20070314113038.GK3557@trapper.coreless.net> <45F7F729.9020104@free.fr> <20070314135825.GL3557@trapper.coreless.net> <20070314141156.GM3557@trapper.coreless.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20070314141156.GM3557@trapper.coreless.net> X-Header-Virus: I am a header virus, put me in your headers too! User-Agent: Mutt/1.5.13 (2006-08-11) X-Content-Scanned: with sophos and spamassassin at mailgw.ntnu.no. X-Virus-Checked: Checked by ClamAV on apache.org Anders Morken: > [...] the page size (Seemed to be 32K in this case [...] Aha. Those 32 kilobyte pages were "overflow pages", created to hold rows that won't fit on a regular page. The regular pages were 4 kilobytes, the default size, but obviously those 6 megabyte blobs had to be split across a few overflow pages. =) That explains why blob workloads suddenly consume a lot more memory than regular workloads with few (if any) overflow pages. Maybe this is common knowledge, but I just hadn't realized. =) Sorry for the noise, just wanted to clear up (my own) confusion. =) -- Anders Morken My opinions may have changed, but not the fact that I am right!