Re: Optimizing for writes. Data integrity not critical

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Optimizing for writes. Data integrity not critical
Дата
Msg-id 428D4146.6000203@familyhealth.com.au
обсуждение исходный текст
Ответ на Optimizing for writes. Data integrity not critical  (Steve Bergman <steve@rueb.com>)
Ответы Re: Optimizing for writes. Data integrity not critical
Список pgsql-performance
Дерево обсуждения 
> I'm doing the writes individually.  Is there a better way?  Combining
> them all into a transaction or something?

Use COPY of course :)

Or at worst bundle 1000 inserts at a time in a transation...

And if you seriously do not care about your data at all, set fsync = off
  in you postgresql.conf for a mega speedup.

Chris

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Optimizing for writes. Data integrity not critical
Следующее
От: "Joel Fradkin"
Дата:
Сообщение: performance on a querry with many group by's any way to speed it up?