Joel Mc Graw <[EMAIL PROTECTED]> writes:
> Assuming that the data is exactly the same, I'm wondering if it is
> better to store it in a single large table or many smaller tables.
> Right now I have upwards of 2000 tables, some containing upwards of
> 10,000 records, and each record contains a large amount of text stored
> in a varchar field.
10K records is in the range of "too small to notice". On the other
hand, 2000 tables is probably more files than you want to be holding
open at once, on most Unixen. You would be much better off with one
table having 20M records, I should think.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
