Re: How large can a PostgreSQL database get?

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Aleksey Tsalolikhin <atsaloli(dot)tech(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How large can a PostgreSQL database get?
Date: 2013-04-17 14:10:22
Message-ID: 20130417141022.GH4602@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Apr 17, 2013 at 06:23:41AM -0700, Aleksey Tsalolikhin wrote:
> Hi. I was promoting PostgreSQL to an AIX/Oracle shop yesterday, they are
> looking to switch to open source to cut their licensing costs, and was asked
> how large a database does PostgreSQL support? Is there an upper bound on
> database size and if so, what it is?

Well, anything over hundreds of gigabytes is going to require tuning,
and above a terrabyte is going to require partitioning. There isn't a
hard limit, but we don't see many serves over tens of terrabytes.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2013-04-17 14:15:36 Re: How large can a PostgreSQL database get?
Previous Message Mark Felder 2013-04-17 13:34:05 Re: How large can a PostgreSQL database get?