Re: Insert speed question - Mailing list pgsql-general

From Richard Huxton
Subject Re: Insert speed question
Date
Msg-id 40BC44D3.6030309@archonet.com
Whole thread Raw
In response to Re: Insert speed question  (Gaetano Mendola <mendola@bigfoot.com>)
List pgsql-general
Gaetano Mendola wrote:
> Josué Maldonado wrote:
>
>> sort_mem = 131072               # min 64, size in KB
>
>
> 128 MB for sort_mem is really an huge ammount of
> memory considering that is not system-wide but
> almost for process ( under certain operations a
> single process can use more then this quantity ).
> Hackers: am I wrong ?

Not a hacker, but you're right. It's the amount of memory *per sort*. Of
course, Josue might have a Terabyte of RAM but it's unlikely.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Connecting to an External DB (repost)
Next
From: Richard Huxton
Date:
Subject: Re: Separating application from data