sure, but this can become really tedious for 1024 partitions,
Well, managing 1024 partitions manually is a tedious job, no matter
what grammar you take: You'll have to deal with 1024 different
partition names.
What do you need so many partitions for?
imagine a structure which is partitioned by day. if you keep data for
3 years (which is perfectly reasonable) you already have 1000
partitions.
some applications produce so much data that splitting it into days is
perfectly reasonable.
if your get 30 GB a day making monthly tables is not too funny
anymore ...
just think of CREATE INDEX or VACUUM ...
having so many tables is not funny but it can be the only reasonable
choice.
best regards,
hans
--
Cybertec Schönig & Schönig GmbH
PostgreSQL Solutions and Support
Gröhrmühlgasse 26, 2700 Wiener Neustadt
Tel: +43/1/205 10 35 / 340
www.postgresql.at, www.cybertec.at
