From: | Joel Mc Graw <jmcgraw(at)databill(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Large table or many small tables? |
Date: | 2002-03-06 21:19:29 |
Message-ID: | TradeClient.0.9.0.FreeBSD-4.2-RELEASE.020306141929C.69148@jmcgraw.databill.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
Problem Domain (for anyone that's interested):
--------------------------------
I receive data transfers from people; a table is created for each data
transfer. Each data transfer has multiple text files. The files are
parsed into pages, and each page is stored in the table just created.
The number of transfers (and thereby the number of tables) is increasing
daily.
Thanks for any input.
------------------------------------------------------
Joel Mc Graw
DataBill, LLC
602-415-1234 ext. 13
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCS d-@ s: a C++++ UB++++ P-- L- E? W++ N w--- O? M+ V
PS+++ PE++ Y+ PGP++ t+ 5++ X tv+ b+ DI++ G e++ h---- r+++ y++++
-----END GEEK CODE BLOCK-----
From | Date | Subject | |
---|---|---|---|
Next Message | mike sears | 2002-03-06 21:25:52 | Re: Linux Distributions |
Previous Message | Andy Ruhl | 2002-03-06 21:01:28 | Re: Linux Distributions |