From: | Alexaki Sofia <alexaki(at)ics(dot)forth(dot)gr> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | |
Date: | 2001-03-14 14:51:45 |
Message-ID: | Pine.GSO.4.10.10103141642010.327-100000@athena.ics.forth.gr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Perdue | 2001-03-14 14:56:35 | PL/pgSQL "compilation error" |
Previous Message | Tom Lane | 2001-03-14 14:49:51 | Re: my pgsql error? |