Hi,

Are there any limitations on number of child tables that can be use in
partitioned table?

I am currently having weekly partitioned tables (using partitioned
view in SQL Server) that I kept for 2 years.
In total, there will be 52 * 2 = 104 tables exist at one time in the
partition.

I am migrating from SQL Server to pg. Can pg support that number of
tables?

How about if I want to convert it as daily tables (356 * 2 years = 712
tables).
Is this recommended?

FYI, currently each weekly table storeing between 28 to 32 millions
records (approx 4-5 millions recs daily)

Thanks,
G