How to split one table to many by column

[lshapsa]

Hi,

I would like to ask what is the best approach to split and migrate a big table to X smaller tables using PL/pgsql.
Running the following "select * from tab1 where col1=Z into tab2" X times, seems not be efficient. I would like to reduce table scans.

Thanks,

[Rabbit]

Why would you want to denormalize the data?