| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
| Cc: | Josué Maldonado <josue(at)lamundial(dot)hn>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Insert speed question |
| Date: | 2004-06-01 08:56:51 |
| Message-ID: | 40BC44D3.6030309@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stijn Vanroye | 2004-06-01 09:33:21 | Re: Large table search question |
| Previous Message | Richard Huxton | 2004-06-01 08:54:07 | Re: Connecting to an External DB (repost) |