Postgres Pro
Downloads
Home   >   mailing lists

Re: How to "unique-ify" HUGE table? - Mailing list pgsql-performance

From Kynn Jones
Subject Re: How to "unique-ify" HUGE table?
Date
Msg-id c2350ba40812241056h7c2feddbx835aeaf0d472bbb2@mail.gmail.com
Whole thread Raw
In response to Re: How to "unique-ify" HUGE table?  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
List pgsql-performance
Tree view
Thank you all for the very helpful advice.  Upping work_mem made it possible for me to generate the table within this century without bringing the server to a near standstill.  I have not yet experimented with GROUP BY, but I'll do this next.

Cheers,

Kynn

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Troubles dumping a very large table.
Next
From: "Dmitry Koterov"
Date:
Subject: Bgwriter and pg_stat_bgwriter.buffers_clean aspects