Received: from ext1.ics.forth.gr (mailgate.ics.forth.gr [139.91.1.2]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2EEqjx19811 for ; Wed, 14 Mar 2001 09:52:45 -0500 (EST) (envelope-from alexaki@ics.forth.gr) Received: from ismene.ics.forth.gr (mailhost.ics.forth.gr [139.91.157.51]) by ext1.ics.forth.gr (8.9.3/ICS-FORTH/V8.2.5-GATE) with ESMTP id QAA21510 for ; Wed, 14 Mar 2001 16:52:43 +0200 (EET) Received: from athena.ics.forth.gr (athena.ics.forth.gr [139.91.183.30]) by ismene.ics.forth.gr (8.8.8/ICS-FORTH/V3) with ESMTP id QAA25371 for ; Wed, 14 Mar 2001 16:49:44 +0200 (EET) Posted-Date: Wed, 14 Mar 2001 16:49:44 +0200 (EET) Organization: Received: from localhost (alexaki@localhost) by athena.ics.forth.gr (8.9.3/ICS-FORTH/V8.2.2C-INTNULL) with ESMTP id QAA02274 for ; Wed, 14 Mar 2001 16:51:45 +0200 (EET) X-Authentication-Warning: athena.ics.forth.gr: alexaki owned process doing -bs Date: Wed, 14 Mar 2001 16:51:45 +0200 (EET) From: Alexaki Sofia To: pgsql-sql@postgresql.org Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200103/272 X-Sequence-Number: 1931 Hello, I have created a table test1(fromuri varchar(350), tovalue(varchar(3000)) and I have created a btree index on the fromuri attribute. The size of the table is 630kb while the size of the index is 417kb. I execute the following query select * from test1 where fromuri like 'http://ww%'; I get the following message NOTICE: PortalHeapMemoryFree: 0x16563a8 not in alloc set! ERROR: AllocSetFree: cannot find block containing chunk This is a bit strange taking into account that the total size of database buffers I have defined is 80Mb Thanks in advance for your help Sofia Alexaki