Re: Performance considerations for very heavy INSERT traffic

Поиск
Список
Период
Сортировка
От PFC
Тема Re: Performance considerations for very heavy INSERT traffic
Дата
Msg-id op.sw0dqyiwth1vuj@localhost
обсуждение исходный текст
Ответ на Performance considerations for very heavy INSERT traffic  (Brandon Black <blblack@gmail.com>)
Ответы Re: Performance considerations for very heavy INSERT traffic  (Brandon Black <blblack@gmail.com>)
Список 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 ?)

В списке pgsql-performance по дате отправления:

Предыдущее
От: Brandon Black
Дата:
Сообщение: Performance considerations for very heavy INSERT traffic
Следующее
От: "Qingqing Zhou"
Дата:
Сообщение: Re: Performance considerations for very heavy INSERT traffic