Postgres Pro
Downloads
Home   >   mailing lists

Re: 15,000 tables - Mailing list pgsql-performance

From Craig A. James
Subject Re: 15,000 tables
Date
Msg-id 438FC3D2.8090202@modgraph-usa.com
Whole thread Raw
In response to Re: Hyperthreading slows processes?  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: 15,000 tables
List pgsql-performance
Tree view 
So say I need 10,000 tables, but I can create tablespaces.  Wouldn't that solve the performance problem caused by
Linux's(or ext2/3's) problems with large directories? 

For example, if each user creates (say) 10 tables, and I have 1000 users, I could create 100 tablespaces, and assign
groupsof 10 users to each tablespace.  This would limit each tablespace to 100 tables, and keep the ext2/3 file-system
directoriesmanageable. 

Would this work?  Would there be other problems?

Thanks,
Craig

pgsql-performance by date:

Previous
From: "Rick Schumeyer"
Date:
Subject: Re: COPY into table too slow with index: now an I/O question
Next
From: "Luke Lonergan"
Date:
Subject: Re: COPY into table too slow with index: now an I/O