Re: Sort memory not being released

Поиск
Список
Период
Сортировка
От dalgoda@ix.netcom.com (Mike Castle)
Тема Re: Sort memory not being released
Дата
Msg-id oc7csxh0g.ln2@thune.mrc-home.org
обсуждение исходный текст
Ответ на Sort memory not being released  ("Jim C. Nasby" <jim@nasby.net>)
Список pgsql-general
In article <20030617212500.GO40542@flake.decibel.org>,
Jim C. Nasby <jim@nasby.net> wrote:
>Of course I wasn't planning on sucking down a bunch of memory and
>holding on to it. :)

What are you worried about?  The unused portions will eventually be paged
out to disk.  On the next sort, you'll spend a little less time allocating
the memory (saving time) and a little more time paging the disk in (taking
time).  Probably, all in all, you'll end up breaking even.

Just because your process has access to a lot of memory, doesn't mean that
it's all in physical memory at once.

Unless your system ran out of physical memory and/or swap, there shouldn't
be an issue.

It may well be than when you up the sort memory, you may also have to up
swap space.  No big deal.

mrc

--
     Mike Castle      dalgoda@ix.netcom.com      www.netcom.com/~dalgoda/
    We are all of us living in the shadow of Manhattan.  -- Watchmen
fatal ("You are in a maze of twisty compiler features, all different"); -- gcc

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

Предыдущее
От: Erik Price
Дата:
Сообщение: Re: JDBC in PostgreSql for Linux
Следующее
От: Dmitry Tkach
Дата:
Сообщение: Re: JDBC in PostgreSql for Linux