how can we use partition table ?

[henryhcface]

now i have a question, because in our project

some tables have too records ,so the speed of the run application is
very slow ,

we plan to use partition table. but what can we do ?

the restriction condition as followers

the original data in the table ,

means how could i move the data .to other partition tables,

and at the same time the foreign key also must be taken

account.

the table have 2 foreign key , namely reference to other tables
and these tables may be change into partition table also.

so how can we use partition table ?
can anyone help me?

our operation system is windows ,and the language is java .



henry

[rski]

I'm not sure if I understand what u need (mostly because of my poor english), but maybe this site would help

http://www.postgresql.org/docs/8.1/interactive/ddl-partitioning.html

[henryhcface]

I'm not sure if I understand what u need (mostly because of my poor english), but maybe this site would help
http://www.postgresql.org/docs/8.1/i...titioning.html

thank you for your help
actually , my english is poor. .