|
Home > Archive > Data Storage > April 2007 > very large databases
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
very large databases
|
|
| byaarov@yahoo.com 2007-04-28, 1:12 pm |
| Hi... we are considering storing images in our database and the number
of images can be quite large...
So the other option is to store the images as files and point to them
from the DB...
To make this decision, i'd like to know what the maximum sizes of
databases are... Can Databses become more than a TB in size?
B
| |
| jcomeau_ictx 2007-04-28, 1:12 pm |
| On Apr 28, 11:10 am, byaa...@yahoo.com wrote:
> Hi... we are considering storing images in our database and the number
> of images can be quite large...
> To make this decision, i'd like to know what the maximum sizes of
> databases are... Can Databses become more than a TB in size?
A websearch found this for Microsoft SQL Server 2005:
http://msdn2.microsoft.com/en-us/library/ms143432.aspx
Database size: 1,048,516 terabytes
I would guess Oracle, DB2, and others would have followed suit, but
this isn't one of my areas of expertise.
| |
| Daniel Philipp 2007-04-28, 7:12 pm |
| byaarov@yahoo.com wrote:
> Hi... we are considering storing images in our database and the number
> of images can be quite large...
>
> So the other option is to store the images as files and point to them
> from the DB...
I don't know, which option is more performant.
> To make this decision, i'd like to know what the maximum sizes of
> databases are... Can Databses become more than a TB in size?
Of course they can, but that will also heavily depend on your underlying
file system. You may have a look at wikipedia or other sources for a
comparison.
Concerning the postgres database system:
Maximum Database Size Unlimited
Maximum Table Size 32 TB
Maximum Row Size 1.6 TB
Maximum Field Size 1 GB
Maximum Rows per Table Unlimited
Maximum Columns per Table 250 - 1600 depending on column types
Maximum Indexes per Table Unlimited
[Source: [http://www.postgresql.org/about/ ]
| |
| Faeandar 2007-04-29, 7:12 pm |
| On 28 Apr 2007 10:10:21 -0700, byaarov@yahoo.com wrote:
>Hi... we are considering storing images in our database and the number
>of images can be quite large...
>
>So the other option is to store the images as files and point to them
>from the DB...
>
>To make this decision, i'd like to know what the maximum sizes of
>databases are... Can Databses become more than a TB in size?
>
>B
Others have posted the fact that most commercial and/or
production-ready Open Source db's are capable of growing without
bound.
However, managing that db and keeping it trim and fast is much more
difficult.
How will you purge data? How long will you keep images in the db?
How long can you wait for a query to be satisfied?
~F
|
|
|
|
|