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