Why is checkpoint so costly?
От | Josh Berkus |
---|---|
Тема | Why is checkpoint so costly? |
Дата | |
Msg-id | 200506211200.56188.josh@agliodbs.com обсуждение исходный текст |
Ответы |
Re: Why is checkpoint so costly?
Re: Why is checkpoint so costly? Re: Why is checkpoint so costly? |
Список | pgsql-hackers |
Folks, Going over some performance test results at OSDL, our single greatest performance issue seems to be checkpointing. Not matter how I fiddle with it, checkpoints seem to cost us 1/2 of our throughput while they're taking place. Overally, checkpointing costs us about 25% of our performance on OLTP workloads. Example: http://khack.osdl.org/stp/302671/results/0/ Can we break down everything that happens during a checkpoint so that we can see where this huge cost is coming from? Checkpointing should be limited to fsyncing to disk and marking WAL files as recyclable, but there seems to be something more. -- --Josh Josh Berkus Aglio Database Solutions San Francisco
В списке pgsql-hackers по дате отправления: