> Yahoo has a 2PB Postgres single instance Postgres database (modified
> engine), but the biggest pure Pg single instance I've heard of is 4TB.
> The 4TB database has the additional interesting property in that they've
> done none of the standard "scalable" architecture changes (such as
> partitioning, etc). To me, this is really a shining example that even
> naive Postgres databases can scale to as much hardware as you're willing
> to throw at them. Of course, clever solutions will get you much more
> bang for your hardware buck.
Can you share some ideas of the particular design of the 4T db, it sounds very interesting :)