Search Postgresql Archives

Re: Quesion about querying distributed databases

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Mar 5, 2025 at 9:44 PM me nefcanto <sn.1361@xxxxxxxxx> wrote:
I once worked with a monolithic SQL Server database with more than 10 billion records and about 8 Terabytes of data. A single backup took us more than 21 days. It was a nightmare.

25 years ago (meaning much slower hardware), I managed a 1TB database.  Backups took about 4 hours.  Could have gotten it down to two hours if I'd wanted to use more tape drives.

Right now, I manage a 5TB database.  Backups take 110 minutes, and that's when using one channel for all IO, writing to not the fastest NAS, and other 3+TB databases backing up to it at the same time.
 
Almost everybody knows that scaling up has a ceiling

And that ceiling is much, much higher than you think it is.
 
, but scaling out has no boundaries.

Except for complexity and fragility. I bet I could get good scaled up performance out of the amount of hardware you're using to scale out.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux