Re: Out of swap space & memory

Well, I didn't set sort_mem, which (does it?) means it defaults to 512.
There are 2 gigs of RAM on the box and one gig of swap space. Should I have
set it to some different value? Thanks for your reply.

Kevin

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Jeff
Sent: Saturday, August 07, 2004 4:31 AM
To: Kevin Bartz
Cc: pgsql-general(at)postgresql(dot)org; 'Manfred Koizar'
Subject: Re: [GENERAL] Out of swap space & memory

On Aug 6, 2004, at 10:32 PM, Kevin Bartz wrote:
>
> -- de-dup the table

> MS SQL Server, with as much RAM and less clock speed, de-dups the
> table in
> about six minutes. The de-duped version has about 26,000,000 rows. The
> final
> line is where Postgres gobbles up all my swap and RAM and then conks
> out
> completely.

What is your sort_mem set to and how much ram is on the box?

--
Jeff Trout <jeff(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match