| 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: | Whole Thread | Raw Message | 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
| 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? |