Re: Large index operation crashes postgres

Поиск
Список
Период
Сортировка
От Frans Hals
Тема Re: Large index operation crashes postgres
Дата
Msg-id 39af1ed21003291017k46b0480en2fe37b27f22bc5fb@mail.gmail.com
обсуждение исходный текст
Ответ на Large index operation crashes postgres  (Frans Hals <fhals7@googlemail.com>)
Список pgsql-general
Paul,

I have checked the different kinds of data in the table for their memory usage.
ST_LineSting is the one that's leaking, the other types complete
indexing without leakage.
Update to Geos 3.2.0 didn't improve the operation.

Kind regards
Frans

2010/3/28 Paul Ramsey <pramsey@cleverelephant.ca>:
> MIght be random, might be a clue, we'll see. So it looks like much of
> the table is two-point lines and points.
>
> P
>
> On Sat, Mar 27, 2010 at 1:16 PM, Frans Hals <fhals7@googlemail.com> wrote:
>
>>  ST_Point        |              | 20648939
>>  ST_MultiPolygon |              |     6188
>>  ST_Polygon      |              |  8054680

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

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: How long will the query take
Следующее
От: Harald Fuchs
Дата:
Сообщение: Re: How to perform text merge