Re: Scaling XLog insertion (was Re: Moving more work outside WALInsertLock)
От | Tom Lane |
---|---|
Тема | Re: Scaling XLog insertion (was Re: Moving more work outside WALInsertLock) |
Дата | |
Msg-id | 7608.1331134118@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: Scaling XLog insertion (was Re: Moving more work outside WALInsertLock) (Simon Riggs <simon@2ndQuadrant.com>) |
Ответы |
Re: Scaling XLog insertion (was Re: Moving more work outside
WALInsertLock)
|
Список | pgsql-hackers |
Simon Riggs <simon@2ndQuadrant.com> writes: > On Wed, Mar 7, 2012 at 3:04 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: >> Alvaro Herrera <alvherre@commandprompt.com> writes: >>> So they are undoubtely rare. �Not sure if as rare as Higgs bosons. >> Even if they're rare, having a major performance hiccup when one happens >> is not a side-effect I want to see from a patch whose only reason to >> exist is better performance. > I agree the effect you point out can exist, I just don't want to slow > down the main case as a result. I don't see any reason to think that what I suggested would slow things down, especially not if the code were set up to fall through quickly in the typical case where no page boundary is crossed. Integer division is not slow on any machine made in the last 15 years or so. regards, tom lane
В списке pgsql-hackers по дате отправления: