Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: How to "unique-ify" HUGE table?
- From: "Kynn Jones" <kynnjo(at)gmail(dot)com>
- To: pgsql-performance(at)postgresql(dot)org
- Subject: Re: How to "unique-ify" HUGE table?
- Date: Wed, 24 Dec 2008 13:56:28 -0500
- Message-id: <c2350ba40812241056h7c2feddbx835aeaf0d472bbb2@mail.gmail.com> <text/plain>
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
- References:
- How to "unique-ify" HUGE table?
- From: Kynn Jones
- Re: How to "unique-ify" HUGE table?
- From: George Pavlov
- Re: How to "unique-ify" HUGE table?
- From: Scott Marlowe
- Re: How to "unique-ify" HUGE table?
- From: Stefan Kaltenbrunner
- How to "unique-ify" HUGE table?
- Prev by Date: Re: Troubles dumping a very large table.
- Next by Date: Bgwriter and pg_stat_bgwriter.buffers_clean aspects
- Previous by thread: Re: How to "unique-ify" HUGE table?
- Next by thread: Troubles dumping a very large table.
- Indexes: