| From: | James Olin Oden <joden(at)lee(dot)k12(dot)nc(dot)us> |
|---|---|
| To: | Gerald Brandt <gbr(at)hvdc(dot)ca> |
| Cc: | pgsql-admin(at)postgreSQL(dot)org |
| Subject: | Re: [ADMIN] Limits on Tables? |
| Date: | 1998-07-28 16:13:48 |
| Message-ID: | 81Jul27.110401edt.35713@gateway.lee.k12.nc.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
> Hi there,
>
> I have an app that has some basic tables. When a new project is created
> in the app, it creates 5 new tables (inherited from some base ones). A
> single project will never go outside of its tables.
>
> What kind of speed problems will I be seeing when there are a lot of
> projects? Say I have 100 projects, that would be 500 tables, plus a
> couple of base tables, say 510 tables.
>
> Am I going to start seeing major problems?
>
Could share with us the tables you are using as base tables? I suspect that
you may not need to do this scheme of duplicating tables, but could rather
have a table that has a project ID, that you use to segregate your project
data amongst these tables. At anyrate I would love to see the tables you
have, and then I would know if how best to help....james
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gerald Brandt | 1998-07-28 16:25:36 | Re: [ADMIN] Limits on Tables? |
| Previous Message | Gerald Brandt | 1998-07-28 14:26:07 | Limits on Tables? |