Majid Azimi <majid(dot)merkava(at)gmail(dot)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
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Mladen Gogala||Date: 2010-12-17 22:26:28|
|Subject: Re: Very Large Table Partitioning|
|Previous:||From: Majid Azimi||Date: 2010-12-17 18:58:30|
|Subject: Very Large Table Partitioning|