Re: XID wraparound and busy databases - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: XID wraparound and busy databases
Date
Msg-id 200708151957.l7FJvjk11780@momjian.us
Whole thread Raw
In response to Re: XID wraparound and busy databases  (Zoltan Boszormenyi <zb@cybertec.at>)
List 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 by date:

Previous
From: Zoltan Boszormenyi
Date:
Subject: Re: XID wraparound and busy databases
Next
From: Chris Browne
Date:
Subject: Re: Index Tuple Compression Approach?