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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Sent: Saturday, August 07, 2004 4:31 AM To: Kevin Bartz Cc: [EMAIL PROTECTED]; '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 <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
