Re: Load Distributed Checkpoints test results
От
PFC
Тема
Re: Load Distributed Checkpoints test results
Дата
Msg-id
op.ttzc47iicigqcu@apollo13
Ответ на
Re: Load Distributed Checkpoints test results (Gregory Maxwell)
Список
Дерево обсуждения
Load Distributed Checkpoints test results Heikki Linnakangas <heikki@enterprisedb.com>
Re: Load Distributed Checkpoints test results ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: Load Distributed Checkpoints test results Heikki Linnakangas <heikki@enterprisedb.com>
Re: Load Distributed Checkpoints test results Gregory Stark <stark@enterprisedb.com>
Re: Load Distributed Checkpoints test results Heikki Linnakangas <heikki@enterprisedb.com>
Re: Load Distributed Checkpoints test results Heikki Linnakangas <heikki@enterprisedb.com>
Re: Load Distributed Checkpoints test results Greg Smith <gsmith@gregsmith.com>
Re: Load Distributed Checkpoints test results Bruce Momjian <bruce@momjian.us>
Re: Load Distributed Checkpoints test results "Joshua D. Drake" <jd@commandprompt.com>
Re: Load Distributed Checkpoints test results Heikki Linnakangas <heikki@enterprisedb.com>
Re: Load Distributed Checkpoints test results Greg Smith <gsmith@gregsmith.com>
Re: Load Distributed Checkpoints test results Heikki Linnakangas <heikki@enterprisedb.com>
Re: Load Distributed Checkpoints test results Greg Smith <gsmith@gregsmith.com>
Re: Load Distributed Checkpoints test results Greg Smith <gsmith@gregsmith.com>
Re: Load Distributed Checkpoints test results Gregory Stark <stark@enterprisedb.com>
Re: Load Distributed Checkpoints test results "Gregory Maxwell" <gmaxwell@gmail.com>
Re: Load Distributed Checkpoints test results Josh Berkus <josh@agliodbs.com>
Re: Load Distributed Checkpoints test results Heikki Linnakangas <heikki@enterprisedb.com>
Re: Load Distributed Checkpoints test results PFC <lists@peufeu.com>
Re: Load Distributed Checkpoints test results Greg Smith <gsmith@gregsmith.com>
Re: Load Distributed Checkpoints test results "Simon Riggs" <simon@2ndquadrant.com>
Re: Load Distributed Checkpoints test results Greg Smith <gsmith@gregsmith.com>
Re: Load Distributed Checkpoints test results Gregory Stark <stark@enterprisedb.com>
Re: Load Distributed Checkpoints test results Josh Berkus <josh@agliodbs.com>
On Fri, 15 Jun 2007 22:28:34 +0200, Gregory Maxwell wrote: > On 6/15/07, Gregory Stark wrote: >> While in theory spreading out the writes could have a detrimental >> effect I >> think we should wait until we see actual numbers. I have a pretty strong >> suspicion that the effect would be pretty minimal. We're still doing >> the same >> amount of i/o total, just with a slightly less chance for the elevator >> algorithm to optimize the pattern. > > ..and the sort patching suggests that the OS's elevator isn't doing a > great job for large flushes in any case. I wouldn't be shocked to see > load distributed checkpoints cause an unconditional improvement since > they may do better at avoiding the huge burst behavior that is > overrunning the OS elevator in any case. ...also consider that if someone uses RAID5, sorting the writes may produce more full-stripe writes, which don't need the read-then-write RAID5 performance killer...
В списке pgsql-hackers по дате отправления