table size

From: "A Palmblad" <adampalmblad(at)yahoo(dot)ca>
To: "General Postgres" <pgsql-general(at)postgresql(dot)org>
Subject: table size
Date: 2004-03-10 16:29:15
Message-ID: 002201c406bc$d463dff0$97019696@AERS04
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to decide whether it is best to use 1 big table or some smaller
tables with less rows for a database. Although Postgres doesn't have a hard
limit on the number of rows, I plan to be inserting, into the biggest and
the next largest tables, around ten million and two million rows,
respectively, a day. With good index choices, when can I expect the number
of rows to affect performance in a large way? Or, will it be best just to
leave all the rows in one continously growing massive table?
-Adam

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2004-03-10 16:33:45 Re: load testing
Previous Message Tom Lane 2004-03-10 16:27:00 Re: bug in rule?