Thread: What is "large"

What is "large"

From
"Sean Carmody"
Date:
Just out of curiosity:

I've noticed a number of exchanges on various PostgreSQL mailing lists along
the lines of

    Original posting:
    > ... we are using a large database: tables having X number of rows ...

    Reply:
    ... that's not a large database! ;) ...

Would a table with around 6,000,000 records (each with, say, 4 fields) be
considered "large" for PostgreSQL?

Sean.



Re: [GENERAL] What is "large"

From
Bruce Momjian
Date:
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> Just out of curiosity:
>
> I've noticed a number of exchanges on various PostgreSQL mailing lists along
> the lines of
>
>     Original posting:
>     > ... we are using a large database: tables having X number of rows ...
>
>     Reply:
>     ... that's not a large database! ;) ...
>
> Would a table with around 6,000,000 records (each with, say, 4 fields) be
> considered "large" for PostgreSQL?

Databases and tables of > 10 Gig would be large.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026