Blocking every 20 sec while mass copying.
От | Benjamin Dugast |
---|---|
Тема | Blocking every 20 sec while mass copying. |
Дата | |
Msg-id | CAB9ggRqtNUngxJjAeD=ZLhkzw5OgkkqVBXkjMXC5j_9V50w-WQ@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Blocking every 20 sec while mass copying.
Re: Blocking every 20 sec while mass copying. Re: Blocking every 20 sec while mass copying. |
Список | pgsql-performance |
Hello,
I'm working on Postgres 9.3.4 for a project.DELETE request : DELETE FROM table WHERE field1 = ? AND field2 = ?;
COPY request : COPY table FROM STDIN WITH CSV
When we insert the data there is some kind of freezes on the databases between requests. Freezes occur about every 20 seconds.
- 1 table to 5 tables to reduces lock contention
- fillfactor on indexes
- commit delay
- fsync to off (that helped but we can't do this)
We mainly want to know why this is happening because it slowing the insert too much for us.
В списке pgsql-performance по дате отправления: