Re: Performance considerations for very heavy INSERT traffic

From: PFC <lists(at)boutiquenumerique(dot)com>
To: blblack(at)gmail(dot)com, pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance considerations for very heavy INSERT traffic
Date: 2005-09-12 21:24:24
Message-ID: op.sw0dqyiwth1vuj@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> I know I haven't provided a whole lot of application-level detail here,

You did !

What about :

- using COPY instead of INSERT ?
(should be easy to do from the aggregators)

- using Bizgres ?
(which was designed for your use case)

- splitting the xlog and the data on distinct physical drives or arrays

- benchmarking something else than ext3
(xfs ? reiser3 ?)

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alex Turner 2005-09-12 21:45:21 Re: Performance considerations for very heavy INSERT traffic
Previous Message Brandon Black 2005-09-12 21:04:06 Performance considerations for very heavy INSERT traffic