[postgis-users] postgis-users Digest, Vol 84, Issue 26

[Kevin Neufeld]

And do you see similar memory usage when you don't use a geometry data type?

ie.
in thread 1:
insert into tmp (id, mytextfield) values (1, 
'abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz');

in thread 2 (to simulate your non-indexed long running query):
select count(*) from tmp where mytextfield like '%hijkl%';

-- Kevin

WANGRUNGVICHAISRI, SHIVESH wrote:
> Regarding the indexing...the test program that I submitted as part of
> this bug report actually is an extract of our real program. In our real
> program, whether or not we have index in there, the leak is present.