how good is PostgreSQL - Mailing list pgsql-general

From Arnold Gamboa
Subject how good is PostgreSQL
Date
Msg-id 00da01c042fa$ef0d7e30$70e808ca@Arnold
Whole thread Raw
List pgsql-general
Hi,

For users of large PostgreSQL and PostgreSQL builders, this is for you.

I'm having a terrible time deciding now. :(

We're about to build a "huge" website now.  I got tied up in signing the
contract without really getting enough information about PgSQL since this
what we plan to implement with PHP (normally we use mySQL but i guess it
does not fit for huge databases like that).

Here's my problem.. We're about to build a site like hitbox.com where there
is a large amount of database required.. If say there is 100,000 users with
1000 page hits per day for each, and everything will be logged, you could
imagine how huge this will be.  I'm just so "nervous" (really, that's the
term) if we implement this and later on experience a slow down or worse than
that, crash in the server.

My questions are:
1. What is the limit for number of records in a table WITHOUT SUFFERING SLOW
DOWN.
2. ....limit in number of tables per database
3. ... limit in number of database.

Thanks for you comments.  I would really appreciate every comment that I'll
receive regarding this.

Arnold


pgsql-general by date:

Previous
From: Ashley Clark
Date:
Subject: Re: list configuration
Next
From: Luis Magaña
Date:
Subject: Permissions on Tables