Re: [ADMIN] Limits on Tables?

Hi there,

I've created my second test, mentioned below.  I now have 150 projects,
with a total of 100,000 records.  This equates down to about 760 tables at
the same time.  PostgreSQL handles this quantity of tables just fine.  My
searches in a particular project are fast, and response is fantastic.  So,
my conclusion....

A high number of tables in PostgreSQL does not slow down access, when you
limit your queries to a small subset of those tables.

Gerald

On 31-Jul-98 Gerald Brandt wrote:
> Hi there,
>
> Okay, I've created a test.  The test has 100 projects, and each project
> has 500 entries.  So basically it created 500 new tables, and 50000
> records.  Speed difference is negligible.  I do not notice a slowdown,
> although I have not done actual timing tests.
>
> Today, I will add 50 more projects with 1000 entries each (again 50000
> records), and essentialy double the size of the database, but not
> drastically increase the number of tables.
>
> Gerald
>
> On 28-Jul-98 James Olin Oden wrote:
>
>>
>>> 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
>>
>>
>>
>
> ---
>#include <std_disclaimer>
>
> Gerald Brandt                          gbr@hvdc.ca
> Manitoba HVDC Research Centre          http://www.hvdc.ca
>

---
#include <std_disclaimer>

Gerald Brandt                          gbr@hvdc.ca
Manitoba HVDC Research Centre          http://www.hvdc.ca