| From: | Joe <svn(at)freedomcircle(dot)net> |
|---|---|
| To: | Matt Miller <mattm(at)epx(dot)com> |
| Cc: | Bob Pawley <rjpawley(at)shaw(dot)ca>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Sizes |
| Date: | 2005-07-01 19:56:56 |
| Message-ID: | 42C5A008.1090803@freedomcircle.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Matt Miller wrote:
> On Fri, 2005-07-01 at 07:50 -0700, Bob Pawley wrote:
>
>>what are the number of schemas, tables and views that would
>>constitute a databse considered to be small, medium or large?
>
>
> Totally subjective opinion:
>
> Small database: few dozen tables/views
> Medium database: 100 tables/views
> Large database: 1000 tables/views
>
> Small table: few dozen rows
> Medium table: few thousand rows
> Large table: millions of rows
Another completely subjective opinion: when people talk about large or very
large databases (VLDB) they usually refer to the amount of data, not the number
of tables or views. For example, a database that occupied 50 GB would be
considered large even it had a dozen tables (most likely with a few of those
having millions of rows). Conversely, a database with 500 tables but occupying
only 1/2 GB would likely be considered small or medium.
Joe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas F. O'Connell | 2005-07-01 20:45:40 | PostgreSQL Hosting |
| Previous Message | Stephane Bortzmeyer | 2005-07-01 19:47:01 | Re: How to uninstall PostGreSql from linux |