Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance considerations for very heavy INSERT traffic - Mailing list pgsql-performance

From PFC
Subject Re: Performance considerations for very heavy INSERT traffic
Date
Msg-id op.sw0dqyiwth1vuj@localhost
Whole thread Raw
In response to Performance considerations for very heavy INSERT traffic  (Brandon Black <blblack@gmail.com>)
Responses Re: Performance considerations for very heavy INSERT traffic  (Brandon Black <blblack@gmail.com>)
List pgsql-performance
Tree view 

> 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 ?)

pgsql-performance by date:

Previous
From: Brandon Black
Date:
Subject: Performance considerations for very heavy INSERT traffic
Next
From: "Qingqing Zhou"
Date:
Subject: Re: Performance considerations for very heavy INSERT traffic