[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] postgis-users Digest, Vol 84, Issue 26
From:       Kevin Neufeld <kneufeld () refractions ! net>
Date:       2009-08-27 20:21:36
Message-ID: 4A96EAD0.7020900 () refractions ! net
[Download RAW message or body]

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.
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]