On Wed, 19 Jan 2005, Richard Huxton wrote: > Hmm - wonder if there might be some memory leak in updates to the R-tree > - it gets used less than B-tree, so it could be. If you reply to this, > make sure you mention your version of PG - one of the developers might > know more. Probably also worth looking in the documentation for 8.0 and > check the release notes section to see if any changes look applicable to > your problem. That's a possibility. I've now dropped all indices, and am trying again. I forgot to post the version in use, it was 7.4.1 - will try to upgrade to v8.0 soon, as it clearly solves another problem I encountered recently. Thanks for all the help. -- Clive Page Dept of Physics & Astronomy, University of Leicester, Tel +44 116 252 3551 Leicester, LE1 7RH, U.K. Fax +44 116 252 3311 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html