Re: Very Large Table Partitioning

Tom Lane wrote:
> Majid Azimi  writes:
>   
>> if we decide to partition table per user we have lots of tables (maybe 
>> more than 100000+) with only 10000 records each.
>> is this a good idea? is there any limit for number of tables?
>>     
>
> No, it's a fantastically bad idea.  Please note the caveats in the
> partitioning documentation --- the facility is not meant for more than
> order-of-a-hundred partitions.  Even if Postgres didn't have issues with
> it, your filesystem might get ill with hundreds of thousands of files in
> one directory.
>
> 			regards, tom lane
>
>   
Tom, at one time you mentioned "getting the proper partitioning". Any 
inklings on what was meant by that and if there was any progress on that?

-- 
 
Mladen Gogala 
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
http://www.vmsinfo.com 
The Leader in Integrated Media Intelligence Solutions