AW: Re[4]: Allowing WAL fsync to be done via O_SYNC

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB
Тема AW: Re[4]: Allowing WAL fsync to be done via O_SYNC
Дата
Msg-id 11C1E6749A55D411A9670001FA687963368251@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Ответы Re: AW: Re[4]: Allowing WAL fsync to be done via O_SYNC  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> >> definitely need before considering this is to replace the existing
> >> spinlock mechanism with something more efficient.
> 
> > What sort of problems are you seeing with the spinlock code?
> 
> It's great as long as you never block, but it sucks for making things

I like optimistic approaches :-)

> wait, because the wait interval will be some multiple of 10 msec rather
> than just the time till the lock comes free.

On the AIX platform usleep (3) is able to really sleep microseconds without 
busying the cpu when called for more than approx. 100 us (the longer the interval,
the less busy the cpu gets) .
Would this not be ideal for spin_lock, or is usleep not very common ?
Linux sais it is in the BSD 4.3 standard.

postgres@s0188000zeu:/usr/postgres> time ustest # with 100 us
real    0m10.95s
user    0m0.40s
sys     0m0.74s

postgres@s0188000zeu:/usr/postgres> time ustest # with 10 us
real    0m18.62s
user    0m1.37s
sys     0m5.73s

Andreas

PS: sorry off for weekend now :-) Current looks good on AIX.


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: ["Stephen C. Tweedie" ] Re: O_DSYNC flag for open
Следующее
От: Larry Rosenman
Дата:
Сообщение: Re: Re[4]: Allowing WAL fsync to be done via O_SYNC