Re: Indexes and Primary Keys on Rapidly Growing Tables

On 2/20/12 2:06 PM, Alessandro Gagliardi wrote:
> . But first I just want to know if people
> think that this might be a viable solution or if I'm barking up the wrong
> tree.

Batching is usually helpful for inserts, especially if there's a unique
key on a very large table involved.

I suggest also making the buffer table UNLOGGED, if you can afford to.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com