Re: Out of memory error

Поиск
Список
Период
Сортировка
От Mark Cave-Ayland
Тема Re: Out of memory error
Дата
Msg-id 4A530E68.3070701@siriusit.co.uk
обсуждение исходный текст
Ответ на Re: Out of memory error  (Paul Smith <paulsmith@pobox.com>)
Список pgsql-general
Paul Smith wrote:

> It's actually ST_Intersects from PostGIS (some of the PostGIS function
> names are still recognize without the leading "ST_").

Not for too much longer - these have been deprecated for a while ;)

> http://postgis.refractions.net/documentation/manual-1.3/ch06.html#id2574404
>
> # select postgis_version();
>             postgis_version
> ---------------------------------------
>  1.3 USE_GEOS=USE_PROJ=1 USE_STATS=1

Can you do a "SELECT postgis_full_version()"? If you're running anything
less than 1.3.6, then the first thing you must do is upgrade. 1.3.6 has
several important memory-leak fixes IIRC.


HTH,

Mark.

--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

В списке pgsql-general по дате отправления:

Предыдущее
От: "Daniel Verite"
Дата:
Сообщение: Re: Feistel cipher, shorter string and hex to int
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Efficiently move data from one table to another, with FK constraints?