| From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
|---|---|
| To: | Patrick Goodwill <goodwill(at)cheese(dot)stanford(dot)edu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: split up tables or one big one? |
| Date: | 2000-08-26 20:21:42 |
| Message-ID: | Pine.BSF.4.21.0008261721140.50750-100000@thelab.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
it all depends on what the data is and how you are going to use it ... if
its going to result in this major JOIN to get results, or several queries,
you are best with teh multi-GB table ...
On Sat, 26 Aug 2000, Patrick Goodwill wrote:
> Hi!
>
> I'm writing a system which i could logically separate it into hundreds,
> perhaps thousands, of tables, or it could put it all into one big table.
> Since each tables could probably only grow to 10s of MBs in size, from a
> design, speed, and scalability perspective, is it perferable to split up
> the tables (as I've currently programmed it) or to put everything into one
> gigantic, multi-GB table? This is for the web, so transaction speed is
> important.
>
> Patrick.
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Guenter | 2000-08-26 20:36:24 | Re: Stripping a prefix |
| Previous Message | Patrick Goodwill | 2000-08-26 20:15:23 | split up tables or one big one? |