Re: Indexes and Primary Keys on Rapidly Growing Tables

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Indexes and Primary Keys on Rapidly Growing Tables
Date: 2012-02-20 23:30:06
Message-ID: 4F42D77E.1050504@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alessandro Gagliardi 2012-02-21 17:59:40 Re: Indexes and Primary Keys on Rapidly Growing Tables
Previous Message Alessandro Gagliardi 2012-02-20 22:06:28 Indexes and Primary Keys on Rapidly Growing Tables