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@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/