Re: Very Large Table Partitioning

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