Postgres Pro
Downloads
Home   >   mailing lists

Re: Indexes and Primary Keys on Rapidly Growing Tables - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Indexes and Primary Keys on Rapidly Growing Tables
Date
Msg-id 4F42D77E.1050504@agliodbs.com
Whole thread Raw
In response to Indexes and Primary Keys on Rapidly Growing Tables  (Alessandro Gagliardi <alessandro@path.com>)
Responses Re: Indexes and Primary Keys on Rapidly Growing Tables  (Alessandro Gagliardi <alessandro@path.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Alessandro Gagliardi
Date:
Subject: Indexes and Primary Keys on Rapidly Growing Tables
Next
From: Alessandro Gagliardi
Date:
Subject: Re: Indexes and Primary Keys on Rapidly Growing Tables