INSERT performance tuning experiences

Поиск
Список
Период
Сортировка
От Robert Burgholzer
Тема INSERT performance tuning experiences
Дата
Msg-id CACT-NG+emD1mG4LUToK=eGe_5aZ12NKC7PwyWSwPZo0t47c20g@mail.gmail.com
обсуждение исходный текст
Ответы Re: INSERT performance tuning experiences  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-admin
Just thought I would relate this, since it is tangible evidence of what is reported in the manuals under WAL tweaking - hope someone finds it useful.

My performance was 76 seconds before tuning versus 7 seconds after tuning.

TASK: Create and populate a table with 30 columns, adding 8,000 rows METHOD: Only INSERT statements (accessed via php which does not allow COPY statements)
SYSTEM: Using an 8.3 install (I know, I know)
WAL CONFIG: changed the default setting of "synchronous_commit = off" to "synchronous_commit = on"
 

--
--
Robert W. Burgholzer
 'Making the simple complicated is commonplace; making the complicated simple, awesomely simple, that's creativity.'  - Charles Mingus

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

Предыдущее
От: Payal Singh
Дата:
Сообщение: Re: Archive fails due to missing backup file
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: INSERT performance tuning experiences