Re: XID wraparound and busy databases

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: XID wraparound and busy databases
Дата
Msg-id 200708151957.l7FJvjk11780@momjian.us
обсуждение исходный текст
Ответ на Re: XID wraparound and busy databases  (Zoltan Boszormenyi <zb@cybertec.at>)
Список pgsql-hackers
Zoltan Boszormenyi wrote:
> >> used a real disk, the secondary used tmpfs as PGDATA. Say whatever you want
> >> about my disk lying about flush, its 75MB/sec transfer rate transfer
> >> rate is real.
> >> So 5 million "real" transaction in 24 hours is not unrealistic.
> >>     
> >
> > 6k xacts / s is five *hundred* million transactions, not five million...
> >   
> 
> Blush. :-) You're right. However a single machine with ramdisk is able 
> to do that.

A battery-backed hard disk controller card can do that too.

--  Bruce Momjian  <bruce@momjian.us>          http://momjian.us EnterpriseDB
http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


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

Предыдущее
От: Zoltan Boszormenyi
Дата:
Сообщение: Re: XID wraparound and busy databases
Следующее
От: Chris Browne
Дата:
Сообщение: Re: Index Tuple Compression Approach?