Re: Very Large Table Partitioning

Tom Lane wrote:
> Majid Azimi <majid.merkava@gmail.com> 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