Jim C. Nasby wrote:
On Tue, Jun 13, 2006 at 04:20:34PM -0700, Mischa Sandberg wrote:
Jim C. Nasby wrote:
What's sort_mem set to? I suspect you simply ran the machine out of
memory.
8192 (8MB). No issue when shared_buffers was 2000; same apps always.
So if all 50 backends were running a sort, you'd use 400MB. The box has
4G, right?

Umm ... yes. "if". 35-40 of them are doing pure INSERTS. Not following your train.

Yep, tested /etc/system segmap_percent at 20,40,60. No significant difference between 20 and 60.
That's pretty disturbing... how large is your database?

~10GB. Good locality. Where heading?

--
Engineers think that equations approximate reality.
Physicists think that reality approximates the equations.
Mathematicians never make the connection.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org

Reply via email to