split up tables or one big one? - Mailing list pgsql-general

From Patrick Goodwill
Subject split up tables or one big one?
Date
Msg-id Pine.BSF.4.21.0008261255020.6083-100000@cheese.stanford.edu
Whole thread Raw
Responses Re: split up tables or one big one?  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: Bill Barnes
Date:
Subject: RE: pgaccess not connecting
Next
From: The Hermit Hacker
Date:
Subject: Re: split up tables or one big one?