GiST memory usage - Mailing list pgsql-hackers

From strk@refractions.net
Subject GiST memory usage
Date
Msg-id 20050813111230.GA27975@keybit.net
Whole thread Raw
Responses Re: GiST memory usage  (strk@refractions.net)
Re: GiST memory usage  (Teodor Sigaev <teodor@sigaev.ru>)
List pgsql-hackers
Hi all.
I've been reported memory limit hits
during a postgis index construction
(GiST index).

The indexed tuples are about 425 millions.
The index key is a box2d object (4*sizeof(float)).

The machine has 4 Gb of RAM, and operations are
peaked at ~2.4 Gb of usage.

Is there a way to detect where is memory hold ?

Is there an index-specific memory context for use
to early release memory blocks allocated during
operations (didn't see any use of memory contexts
in the contrib/rtree_gist) ?

TIA

--strk;



pgsql-hackers by date:

Previous
From: Marko Kreen
Date:
Subject: Re: openbsd, plpython, missing threading symbols
Next
From: strk@refractions.net
Date:
Subject: Re: GiST memory usage