Re: Out of swap space & memory

From: Jeff <threshar(at)torgo(dot)978(dot)org>
To: "Kevin Bartz" <kbartz(at)loyaltymatrix(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>, "'Manfred Koizar'" <mkoi-pg(at)aon(dot)at>
Subject: Re: Out of swap space & memory
Date: 2004-08-07 11:30:51
Message-ID: 3C85E303-E865-11D8-A672-000D9366F0C4@torgo.978.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jiri Nemec 2004-08-07 14:16:54 Rounding in PGSQL
Previous Message Gaetano Mendola 2004-08-07 10:19:59 Re: constraint expression